Forum Discussion
Studio_2
Jul 19, 2019Copper Contributor
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 ...
tauqeeracma
Jul 19, 2019Iron Contributor
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
Studio_2
Jul 22, 2019Copper Contributor
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