subtraction

  • Thread starter Thread starter Nish
  • Start date Start date
N

Nish

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?
 
Yes... and I got
#VALUE!
Tried reformating the cell to Number, then accounting, then currency.
Nothing worked.
Any ideas?
nish
 
Nish said:
Yes... and I got
#VALUE!
Tried reformating the cell to Number, then accounting, then currency.
Nothing worked.
Any ideas?
nish
Click to expand...
Are you sure E5 and E6 have numbers in them?

Bill
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Database Formula 4
hide #div/0 2
I need to add multiple cells then subtract them from one cell c4+c6+c7+c9+c10+c11 and subtract them 1
Subtracting text 3
Copy condtional formatting in XL2007 for Windows 1
offset() function #VALUE! 5
Formula 2
subtract times with a negative result 1

Back
Top