Active Member
February 24, 2021
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!
September 9, 2020
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)