If negative number than 1+2, if posative number than 1

C

Cheryl

how would you enter the formula for:
if A4 is a negative number than add A4+A5, but if it is not a negative
number than just A5?
 
E

Elkar

Try this:

=MIN(A4,0)+A5

The MIN function returns the lower of the 2 values (A4 or 0). This is then
added to A5.

And here's another option, using an IF statement:

=IF(A4<0,A4+A5,A5)

HTH,
Elkar
 

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

Top