Log In
Register
Home
Active Member
February 24, 2021
Offline
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!
February 24, 2021
Offline
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.
Active Member
February 24, 2021
Offline
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.
February 24, 2021
Offline
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?
July 16, 2010
Offline
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.
September 9, 2020
Offline
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
1 Guest(s)
