Formula

[Greywolf]

Hi there!

Could really use the help. I have a sheet where I need to
evaluate different scenarios.


If G26-G28>0 then G34=0, G36=0 and G39=0

But if G26-G28<0, answer for G34 depends on the following:

If A28>G32, then answer would be 0
If A28<G32 but >0, then answer would be A33*50%
If A33=0, then answer would be 0

Also if G26-G28<0, answer for G36 depends on the following:

If A28>G32, then answer would be 0
If A28<G32 but >0, then answer would be (G32-A33)*25%
If A33=0, then answer would be 0

Thanks a bunch!!

 

[Guest]

Firstly you did very good by putting out the precise cell numbers in the
question. So now you will have to copy and paste these formulae directly into
the cells.
put G34=IF(G26>G28,0,IF(A28>G32,0,IF(A28>0,0.5*A33,0)))

and G36=IF(G26>G28,0,IF(A28>G32,0,IF(A28>0,IF(A33=0,0,0.25*(G32-A33)),0)))

You have not specified the else condition for G39 but if it is on the same
lines you can build a similar formula.

Also if the nested 'IF's are too complicated to understand you can write a
macro in VB-script where you can write IF within a IF statement. Still logic
will be same.

Vikrant