Forum

Thank you Mynda, that would do it. On this occasion, a custom list was my best solution. Henry

Hi Mynda I don't know why it didn't occur to me before, but I tried looking at a copy of the file on my laptop last night; and no problem! It was a...

Thank you Mynda, I have done that and also included the full error message. And thank you also for the lesson in the first place, as well as all th...

Sorry, works for me, and I can't imagine why it doesn't for you. Did you copy and paste the formulas? Do all the cells F3:J3 contain numbers?

try in M3 =if(L3=0,(F3+G3+H3+J3)*0.15,"") or =if(L3=0,sum(F3:J3)*0.15,"") assuming you want the result of the summation multiplied by .15 as oppose...