C
Colinbonnes
Hi Folks
I am working on a spreadsheet and am using this formula:
=IF(E2="Purchases","Yes"," ")
As you know if the cell E2 contains the work purchases, this cell will
display the word Yes. I actually want the cell this formula is in (G2) to
display the value that is located in cell F2 instead of Yes. Is this even
possible, i've tried several options but obviously don't have the knowledge
to work this one out myself.
Any help would be greatly appreciated!
I am working on a spreadsheet and am using this formula:
=IF(E2="Purchases","Yes"," ")
As you know if the cell E2 contains the work purchases, this cell will
display the word Yes. I actually want the cell this formula is in (G2) to
display the value that is located in cell F2 instead of Yes. Is this even
possible, i've tried several options but obviously don't have the knowledge
to work this one out myself.
Any help would be greatly appreciated!