Hello, It's been quite sometime since I had to use Excel for anything other than basic stuff, so my skills have become rusty. I am trying to use the IF function and I'm not getting what I need. Here is what I am looking for. If L3=0 then I need M3 to equal the total of F3+G3+H3+J3 *.15. Can someone help me? Thanks!
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 opposed to just J3.
Thanks for the suggestion, I have tried those and get errors 508 (brackets don't add up) and 509 (missing operator). I feel those should work, but they aren't.
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?
Sometimes the double quotes get copied in a different style when copying from web pages. I would try entering the formula by typing it in yourself to see if that helps. If not, share a screenshot of your formula or a sample Excel file.
Hi Laura,
When you post a question, it is a good idea to specify whether you are using Excel or Calc or... The errors you mention seem to come from Calc. You cannot simply copy and paste henry's formula because Calc uses other settings. For example, on my machine I had to replace the ',' with ';'. The easiest way is to understand the formula and then write it in Calc, taking care of the help information.
BR,
Lionel
Once I typed it in rather than copy/paste, it is working like it should. Thanks for the help everyone!
