"if" formula

[sonner702]

=IF(E5>0,E5+D6,0) how can have this add and subtract

 

[ccordner]

Add and subtract what?

 

[sonner702]

the formula will only add the cell I cant get it to subtract

 

[Ruddles]

=IF(E5>0,E5+D6,0) how can have this add and subtract

This formula means: if E5 is greater than zero, place E5+D6 in this cell (the cell the formula is in), otherwise place 0 in this cell.

The bit I've highlighted in red can be any arithmetic expression, so it could be E5+D6-F7-99, for example.

The bit I've highlighted in blue can also be any arithmetic expression, so it could be E5-D6, for example.

Does that answer your question?

 

[Taul]

if I have understood correctly, do you mean

=IF(E5>0,E5-D6,0)

 

[PCRIDE]

yes that is correct.

E5+D6 you can add or subtract, or multiply/divide

 

[Ruddles]

Or exponentiate: E5^D6