Nested IF in Sliding Scale Formula

[jaclynresendez]

Sorry. I know there is a simple solution to this and I’m just blind to it.

Calculating Sliding Scale Percentage

Current Formula in cell A46
=IF($B$33<5000,”.007”,IF($B$33<10000,”.006”,IF($B$33>9999,”.005”,””)))*10

This works perfect, however I need this formula to consider the value of A43. If A43=0, then A46=0. If A43 holds any other value then I need it to continue with the above calculation. Any help would be greatly appreciated.

Thanks!

 

[AlphaFrog]

Try something like this

=IF(A43=0,0,IF($B$33<5000,0.07,IF($B$33<10000,0.06,0.05)))

 

[jaclynresendez]

Try something like this

=IF(A43=0,0,IF($B$33<5000,0.07,IF($B$33<10000,0.06,0.05)))

See. You’re amazing. I KNEW I had over-complicated that initial formula, but it worked so I didn’t mess with it. Truthfully, I’m so cross-eyed right now that I’m calling it a day. Thank you so much for the quick response and taking the time to provide a simple solution to a tired girl. I appreciate you.

-Jac

PS. You’re my best friend