I need help creating a nested if/and statement in Excel using the following parameters:
See if this works
=IF(J28<17,0,IF(J28<=25, J27*0.12, IF(J28<=30, J27*0.15, IF(J28<=35, J27*0.2, IF(J28<=40, J27*0.25, J27*0.3)))))
You may have to adjust for your boundary conditions. For example, if the value is 25, do you want to multiply by 12% or 15%?
Good luck,
Paul
×