Complicated Nested IF function - Question

[skathleenr]

I'm working on a function (see below) and need to add to the bolded section. I want it to keep that value as the result, unless that value is greater than 20% of T15. What type would you use and how would you write that?

=IF(AND(O15>0,I15<2008,F15=3,S15="A-1"),($B$10-T15),IF(AND(O15>0,I15<2008,F15=2,S15="A-1"),($E$10-T15),0))

 

[skathleenr]

If $b$10 > 20% of T15, then 20% of T15 should be the result.

 

[Scott Huish]

The first thing to do to make these simpler is to get the same conditions together instead of repeating them over and over. Does this work for you?

=IF(AND(O15>0,I15<2008,S15="A-1"),IF(F15=3,IF($B$10>T15*0.2,T15*0.2,$B$10-T15),IF(F15=2,$E$10-T15,0)),0)

 

[Ken Cowen]

the result of what?
It seems like the result should be true or false, rather than 20% of T15 or something else.

 

[Scott Huish]

There is math in the original formula. The op wants to return B10-T15, unless B10 > 20% of T15 and then want's return that, in the bolded section of the original formula.