More than 1 "IF" function

[Overdahill]

Hi,

I'm trying to configure a formula that would configure its contents based on data inputted into another cell, allow me to explain.

Ie/

Cell A1 has 2 drop-down options, either 0.5 or 1, what formula do I need to use to get cell B1 to formulate 50 if A1 states 0.5, and 100 if A1 states 1 based on the dropdown options?

Can anyone help please? I'm screwing my brain over this.

[PaulM100]

try: =if(a1=0.5,50,if(a1-1,100,""))

[Fluff13]

Why not just
=A1*100
or to return "" if A1 is blank
=IF(A1="","",A1*100)

[Overdahill]

Perfect, thank you!! Is there anyway that I can make cell B1 remain 0 unless either 0.5 or 1 is entered into A1?

[PaulM100]

Change "" with 0

[Fluff13]

Did you try the first of my suggestions?