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
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

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

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
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies