ExcelBanter - subtraction

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - subtraction (https://www.excelbanter.com/excel-discussion-misc-queries/226812-subtraction.html)

Nish

subtraction

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?

Mike H

subtraction

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?

Nish

subtraction

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?

Bill Sharpe

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

All times are GMT +1. The time now is 06:13 AM.