How to make drop down list to change formulas in cell?

Originally Posted by newdoverman

Try this

Formula:

=IF(B5="AA44",B6/5,IF(B5="BB",B6/2.5,""))

I get an error with this too could you try if it works in your Excel?