Home

Excel Formula HELP PLEASE

%3CLINGO-SUB%20id%3D%22lingo-sub-764793%22%20slang%3D%22en-US%22%3EExcel%20Formula%20HELP%20PLEASE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-764793%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20looking%20to%20use%20two%20cells%20to%20determine%20if%20a%20third%20cell%20should%20be%20copied%20to%20another%20cell%20in%20sheet.%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20cells%20I%20will%20be%20using%20will%20be%2C%3C%2FP%3E%3CP%3E%5BSpend%2FProjection%5D%2C%20%5BFunder%5D%2C%20%5BAmount%5D%3C%2FP%3E%3CP%3EBasically%20I%20need%20a%20formula%20like%20if%20spend%2Fprojection%20%3D%20spend%2C%20then%20find%20Funder%20heading%20and%20copy%20and%20paste%20the%20amount%20into%20the%20proper%20heading%20and%20if%20Spend%2FProjection%20%3D%20projection%20then%20leave%20heading%20blank.%3C%2FP%3E%3CP%3ECan%20anyone%20please%20help%20me%20with%20this.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-764793%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-765043%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%20HELP%20PLEASE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-765043%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F379014%22%20target%3D%22_blank%22%3E%40Studio_2%3C%2FA%3E%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20attached%20a%20sample%20file.%20Please%20refer%20it.%20You%20may%20also%20share%20your%20actual%20file%20so%20that%20more%20suitable%20solutions%20can%20be%20found.%20Thanks%2C%3C%2FP%3E%3CP%3ETauqeer%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-765858%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%20HELP%20PLEASE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-765858%22%20slang%3D%22en-US%22%3EPlease%20illustrate%20your%20given%20data%20and%20desired%20results%20through%20a%20sample%20file.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-767111%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%20HELP%20PLEASE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-767111%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F239215%22%20target%3D%22_blank%22%3E%40tauqeeracma%3C%2FA%3E%26nbsp%3BI%20have%20it%20sorted%20basically%20all%20I%20need%20now%20is%20this%20formula%20to%20return%20a%20blank%20cell%20if%20the%20other%20cells%20are%20blank%20the%20formula%20is%3B%26nbsp%3B%3DIF(E10%3D%22EA%2FENIC%22%2CIF(F10%3D%22Spent%22%2CD10%2CIF(F10%3D%22Projection%22%2C0)))%3C%2FP%3E%3CP%3Ethis%20does%20near%20enough%20everything%20I%20want%20it%20too%20except%20it%20returns%20false%20is%20cells%20E10%20and%20f10%20are%20empty%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Studio_2
New Contributor

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
Highlighted

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

Highlighted
Please illustrate your given data and desired results through a sample file.

@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

Related Conversations
Power Query/Pivot - Hours not in chronological order
Shahria3 in Excel on
0 Replies
How to add scale breaks in an Excel graph?
Ruben805 in Excel on
0 Replies
Tabellenbereich dynamisch erweitern oder reduzieren?
TheSoulrester in Excel on
0 Replies
Help with data valiation (indirect function)
novakdz in Excel on
0 Replies
Sous totaux excel
Artus _Ophlie in Excel on
0 Replies
How do I lock a excel file that is password protected
dogacakdag in Excel on
3 Replies