Jupiter1Copper ContributorDec 11, 2020help with Formula 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 someon...Show More
TwifooSilver ContributorDec 11, 2020Jupiter1 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")
Jupiter1Copper Contributor to TwifooDec 14, 2020Twifoo Thank you so so much, YOU GOT IT! All working perfectly now.Really appreciate all your help!Best wishes
