Excel IF country

[David Harrison]

I am having trouble devsing the correct IF function.

Briefly i am doing a cashflow forecast and i am stuck on
this last bit.

I need to select a cell if it has an "A" in it i need the
finction cell to call up a certain figure in another cell
and if the original cell has "F" in it i need it to call
up the figure from a different cell. Demonstration below
if your lost. i think i am just typing it.

Cell B4 has "A" then it needs to call the figure in B6
and put it in cell B20.

Cell B4 has "F" then it needs to call the figure in B7
and put it in cell B20.

If anyone can help then please repond.

Many Thanks
David

 

[Andy B]

David

What do you want in the cell if B4 has neither A nor F?

One option is to put this in B20:
=if(B4="F",B7,B6)
This will test for F in B4, if it is an F, it will put whatever is in B7
into the cell. If it is not an F, it will put whatever is in B6 into the
cell. The alternative is:
=if(B4="A",B6,B7)
Another option is:
=if(B4="A",B6,if(B4="F",B7,"something else"))
This gives you the option of putting something in the cell if B4 is neither
F nor A

Hope this helps

Andy.