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

Enter this formula in G6:

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

Originally Posted by majosum

Enter this formula in G6:

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

Excel says the formula contains an error.

I'm sorry. When I saw AA44, I assumed it was a cell reference to the column AA. Now that I see you only wanted BB as well, try this:

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

My last formula was checking to see if B5 equaled the value in cell AA44.

Originally Posted by majosum

I'm sorry. When I saw AA44, I assumed it was a cell reference to the column AA. Now that I see you only wanted BB as well, try this:

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

My last formula was checking to see if B5 equaled the value in cell AA44.

Still getting an error. Could you try with your Excel?