help with Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1979875%22%20slang%3D%22en-US%22%3Ehelp%20with%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1979875%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20multiple%20formulas%20in%20one%20cell%20and%20want%20to%20add%20the%20results%20together%20and%20then%20divide%20the%20total%20by%20a%20value%20of%20.30%3C%2FP%3E%3CP%3EI%20have%20this%20so%20far%20but%20I'm%20not%20getting%20the%20correct%20result.%20I%20hope%20someone%20can%20point%20out%20where%20I'm%20going%20wrong%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIFERROR((AA3%2BG3)%2C%22NOT%20AVAILABLE%22)%2B((VLOOKUP(B3%2CColour!%24A%242%3A%24B%247%2C2%2CFALSE)%2F0.30))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1979875%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1979956%22%20slang%3D%22en-US%22%3ERe%3A%20help%20with%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1979956%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F656507%22%20target%3D%22_blank%22%3E%40Jupiter1%3C%2FA%3E%26nbsp%3BBest%20to%20upload%20your%20schedule%20(without%20confidential%20information)%20as%20it%20is%20not%20clear%20what%20you%20want%20to%20achieve.%20Let%20be%20understanding%20what's%20wrong.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20first%20part%20of%20your%20formula%20(before%20the%20%2B%20sign)%20doesn't%20make%20sense%20at%20all.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1980920%22%20slang%3D%22en-US%22%3ERe%3A%20help%20with%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1980920%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F656507%22%20target%3D%22_blank%22%3E%40Jupiter1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20guess%20you%20should%20modify%20your%20formula%20to%20this%3A%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DIFERROR(SUM(AA3%2CG3%2CVLOOKUP(B3%2CColour!%24A%242%3A%24B%247%2C2%2C0))%2F0.30%2C%22NOT%20AVAILABLE%22)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1984927%22%20slang%3D%22en-US%22%3ERe%3A%20help%20with%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1984927%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20so%20so%20much%2C%20YOU%20GOT%20IT!%20All%20working%20perfectly%20now.%3C%2FP%3E%3CP%3EReally%20appreciate%20all%20your%20help!%3C%2FP%3E%3CP%3EBest%20wishes%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi,

 

I have multiple formulas in one cell and want to add the results together and then divide the total by a value of .30

I have this so far but I'm not getting the correct result. I hope someone can point out where I'm going wrong?

 

=IFERROR((AA3+G3),"NOT AVAILABLE")+((VLOOKUP(B3,Colour!$A$2:$B$7,2,FALSE)/0.30))

 

Many thanks

 

 

5 Replies

@Jupiter1 Best to upload your schedule (without confidential information) as it is not clear what you want to achieve. Let be understanding what's wrong.

 

The first part of your formula (before the + sign) doesn't make sense at all.

@Jupiter1 

I guess you should modify your formula to this: 

=IFERROR(SUM(AA3,G3,VLOOKUP(B3,Colour!$A$2:$B$7,2,0))/0.30,"NOT AVAILABLE")

@Twifoo 

Thank you so so much, YOU GOT IT! All working perfectly now.

Really appreciate all your help!

Best wishes

 

 

 

@Riny_van_Eekelen 

Thank you for your reply and having taken the time to look at this for me. 

Many thanks

 

You're perfectly welcome!