Having trouble writing an IF, AND, AND, OR Equation. Wishing to based on what the dollar amount in column D and the desired choice for a percentage, I believe I came close but no cigar. Spreadsheet is available. The AND should be if cell D is greater than zero, then do X, Y, Z, based on the choice input. Thanks Joe
Cells
F D G I K M
Choices for Column F
O
S
W
I
Cell D - Dollar Amount say $5000
Cell G - =IF(AND([@[TL_EST]=]=>0,[@KEY]="S"),ROUND([@[TL_EST]]*A!$B$11,2))
Cell I - =IF(AND([@[TL_EST]=]=>0,[@KEY]="S"),ROUND([@[TL_EST]]*A!$B$11,2))
Cell K - =IF(AND(OR(D15>0,F15="W"),F15="O"),D15)
Cell M - =IF(AND(OR(D15>0,F15="O"),F15="W"),D15)
Cells
F D G I K M
Choices for Column F
O
S
W
I
Cell D - Dollar Amount say $5000
Cell G - =IF(AND([@[TL_EST]=]=>0,[@KEY]="S"),ROUND([@[TL_EST]]*A!$B$11,2))
Cell I - =IF(AND([@[TL_EST]=]=>0,[@KEY]="S"),ROUND([@[TL_EST]]*A!$B$11,2))
Cell K - =IF(AND(OR(D15>0,F15="W"),F15="O"),D15)
Cell M - =IF(AND(OR(D15>0,F15="O"),F15="W"),D15)
