Forum Discussion
Excel Formula HELP PLEASE
Hi All
I am looking to use two cells to determine if a third cell should be copied to another cell in sheet.
The cells I will be using will be,
[Spend/Projection], [Funder], [Amount]
Basically I need a formula like if spend/projection = spend, then find Funder heading and copy and paste the amount into the proper heading and if Spend/Projection = projection then leave heading blank.
Can anyone please help me with this.
3 Replies
- Please illustrate your given data and desired results through a sample file.
Hi Studio_2
I have attached a sample file. Please refer it. You may also share your actual file so that more suitable solutions can be found. Thanks,
Tauqeer
tauqeeracma I have it sorted basically all I need now is this formula to return a blank cell if the other cells are blank the formula is; =IF(E10="EA/ENIC",IF(F10="Spent",D10,IF(F10="Projection",0)))
this does near enough everything I want it too except it returns false is cells E10 and f10 are empty
