Dec 11 2020 06:25 AM
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
Dec 11 2020 06:39 AM
@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.
Dec 11 2020 11:38 AM
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")
Dec 14 2020 02:53 AM
Thank you so so much, YOU GOT IT! All working perfectly now.
Really appreciate all your help!
Best wishes
Dec 14 2020 02:59 AM
Thank you for your reply and having taken the time to look at this for me.
Many thanks