Help with If statement

[robwatson8989]

Trying to automate some math for price updates. Unit of measure in E1, price in F1. Trying to reduce all pricing to each price.

If E1 = 'EA', F1*1
If E1 = 'C',F1/100
if E1 - 'M',F1/1000

Here is what I have so far, any help would be greatly appreciated.

=IF(E1='EA',F1*1,IF(E1='C',F1/100,IF(E1='M',F1/1000)))</SPAN>

 

[ExcelToDAX]

How about using the SWITCH function?

=SWITCH(E1,"EA",F1*1,"C",F1/100,"M",F1/1000)

 

[Joe4]

Welcome to the Board!

Excel requires double-quotes for text entries, i.e.

=IF(E1="EA",F1*1,IF(E1="C",F1/100,IF(E1="M",F1/1000)))