dbaspot
Tags Register FAQ Calendar Search Today's Posts Mark Forums Read

HELP WITH NEGATIVE CALCULATION - Spreadsheets

This is a discussion on HELP WITH NEGATIVE CALCULATION - Spreadsheets ; When I use Excel to calculate 10*10-10 I get a negative 90 result, minus 90. I thought multiplication occurs first so 10*10 is 100 minus 10 is positive 90. Can someone explain to me why formula brings a negative result? ...


Home > Database Forum > Other Technologies > Spreadsheets > HELP WITH NEGATIVE CALCULATION

Reply

 

LinkBack Thread Tools Display Modes
  #1  
Old 11-22-2007, 04:29 AM
Database Bot
 
Join Date: Sep 2009
Posts: 1,236,254
Database Administrator is on a distinguished road
Default HELP WITH NEGATIVE CALCULATION

When I use Excel to calculate 10*10-10 I get a negative 90 result, minus 90.
I thought multiplication occurs first so 10*10 is 100 minus 10 is positive
90.

Can someone explain to me why formula brings a negative result?

Thanks,
Alexandra



Reply With Quote
  #2  
Old 11-22-2007, 07:35 AM
Database Bot
 
Join Date: Sep 2009
Posts: 1,236,254
Database Administrator is on a distinguished road
Default Re: HELP WITH NEGATIVE CALCULATION

Don't know here; in Lotus it comes to a positive 90.


--
Don
Vancouver, USA


"Klex" wrote in message
news:iaOdnY4Hg9p6oNjanZ2dnUVZ8h6dnZ2d@bt.com...
> When I use Excel to calculate 10*10-10 I get a negative 90 result, minus
> 90. I thought multiplication occurs first so 10*10 is 100 minus 10 is
> positive 90.
>
> Can someone explain to me why formula brings a negative result?
>
> Thanks,
> Alexandra
>
>
>



Reply With Quote
Reply

Thread Tools
Display Modes



All times are GMT -4. The time now is 12:03 PM.