sum if help

[martins]

I would like to return a value in one cell if the criteria in another cell is met

e.g. If cell A1 = X then B1 = 5
If A1 blank then B1 = 0

[starguy]

I would like to return a value in one cell if the criteria in another cell is met

e.g. If cell A1 = X then B1 = 5
If A1 blank then B1 = 0

Try this in B1

=IF(A1="X",5,IF(A1="",0))

[Teethless mama]

I would like to return a value in one cell if the criteria in another cell is met

e.g. If cell A1 = X then B1 = 5
If A1 blank then B1 = 0

=(A1="x")*5