If < 0 Then

[vessii80]

Hi everyone,
I need help from you.
I have following:

B3 5
B4 23

and below

B10 20

I want to write a formula in C 3 saying:
If (B5-B10)>0 the real result ,If (B5-B10)=<0 then showing 0, and in C 4 showing the result of B4 minus the rest.
So in this example we have:
1. B5-B10=-15, so in C3 we must have 0 and in C 4=8, B4-(-(B5-B10))

Thank you in advance.

Iva

 

[Richard Schollar]

Hi & Welcome to the Board

For the first part (I didn't understand what you were asking for the second) you could use:

=MAX(0,B5-B10)

 

[vessii80]

Hi,
And thank you for the reply.

I'll try to explain:

If the result If (B5-B10)>0 in C 3 to be shown the positive result, if it's negative to show zero

regards,

Iva

 

[Richard Schollar]

Yes, that is handled by the formula I have already given you. it was the what you wanted next I didn't understand.

 

[vessii80]

The next part is:

If the result is negative to take the value from B4 and and extract the negative result from it, showing it in C 4

 

[Richard Schollar]

Perhaps:

=IF(B5-B10<0,B4+B5-B10,"")

in C4.