Thread: subtraction
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Bill Sharpe Bill Sharpe is offline
external usenet poster
 
Posts: 348
Default subtraction

Nish wrote:
Yes... and I got
#VALUE!
Tried reformating the cell to Number, then accounting, then currency.
Nothing worked.
Any ideas?
nish


"Mike H" wrote:

Hmmm,

did you try this in F6

=E5-E6

Mike

"Nish" wrote:

Mine is a simple one I think...
I need a formula to subtract one cell from another.
EX:
E5-E6 with result in F6
Can anyone help?

Are you sure E5 and E6 have numbers in them?

Bill