Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula
Hi there! Could really use the help. I have a sheet where I need to evaluate different scenarios. If G26-G280 then G34=0, G36=0 and G39=0 But if G26-G28<0, answer for G34 depends on the following: If A28G32, 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 A28G32, 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!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula
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(G26G28,0,IF(A28G32,0,IF(A280,0.5*A33,0)) ) and G36=IF(G26G28,0,IF(A28G32,0,IF(A280,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 "Greywolf" wrote: Hi there! Could really use the help. I have a sheet where I need to evaluate different scenarios. If G26-G280 then G34=0, G36=0 and G39=0 But if G26-G28<0, answer for G34 depends on the following: If A28G32, 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 A28G32, 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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |