Forum Discussion

Jupiter1's avatar
Jupiter1
Copper Contributor
Dec 11, 2020

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

 

 

excel

5 Replies

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    Dec 11, 2020

    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")
    • Jupiter1's avatar
      Jupiter1
      Copper Contributor
      Dec 14, 2020

      Twifoo 

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

      Really appreciate all your help!

      Best wishes

       

       

       

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Dec 11, 2020

    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.