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

# Re: help with Formula

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

# Re: help with Formula

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")``

# Re: help with Formula

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

Best wishes

# Re: help with Formula

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

Many thanks

# Re: help with Formula

You're perfectly welcome!