Excel IF formula

Copper Contributor
Hi !
I want to create an IF formula that if it was "good" gives 52
And if it was "bad" gives 60
How to do it ?
2 Replies
Hello Mohammed,
I will assume that your data is on A1, try this formula
=IF(A1="good",52,IF(A1="bad",60,))

@Mohammed675 

As variant

=(A1="good")*52 + (A1="bad")*60