Need help with "if" and "or" formula

dlvgolf

New Member
Joined
Dec 16, 2004
Messages
19
I have a cell (A1) that will have a "G" or a "B" or be empty.
I have another cell (B1) that will have a number in it
I need a forumula that will populate a cell as follows:
if A1 = "G" add 2
if A1 = "B" subtract 2
if A1 = blank add 0
and then add B1


Thanks for your help.
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

Watch MrExcel Video

Forum statistics

Threads
1,113,811
Messages
5,544,437
Members
410,610
Latest member
renatha prado
Top