IF Function to do a calculation help

[harpsichord]

I have a roadspeed of a car in m/s in cell A1 and a drop down menu of different units in C1 (which unclude mph and kmh).

I have used the following IF function in B1 to convert the number to the unit selected from the dropdown menu:

=IF(C1="mph","=A1*2.23693629",IF(C1="kmh","=A1*3.6"))

However say if kmh was selected, B1 literally just shows =A1*3.6 and does not actually calculate it.

Is there away to get it to calculate it instead of just showing the text message?

Cheers

[Søren Larsen]

Just remove the " around your calculations. Putting something in " " converts it to text.

And remove the = within the =IF() statement. Like this:

=IF(C1="mph",A1*2.23693629,IF(C1="kmh",A1*3.6))

[harpsichord]

Ha its worked, didn't realise it was that simple.

Thanks for that

[Søren Larsen]

No problem!