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
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