Tacoma3G is a beginner-friendly 3rd Generation Toyota Tacoma Forum (2016-2023 model-years). We are a community of people who are focused on good information and good vibes.
=IF(V6>0,V6+2.5,V6) works bit how do I add in the other sum range (J14:J25)?Sup nerd.
Deleting the last A1 will show a FALSE result.
If it's 0, it will return as 0.
Can hide 0's.
How do you want it to add? I got that if it's greater than 0, to add 2.5. What else are you trying to do?
Just jumped on my work pc and it worked. Thanks for the help mate!
So it was just adding 2.5 to anything over 0? Did you mean to put it into all the other columns? What were you using the range for? Now I'm curious. I'm just one of those analytical problem solving minds.
Working on a time and attendance tracker following a policy change that implemented separate occurrence values for employees in a 90 day introductory period. The formula above was being placed in a cell that was supposed to total the occurrence values in both tables of tenure, which have a 2.5 point difference, to adjust for the difference in points - while maintaining an existing corrective action level. Problem was introductory periods showing zero occurrences were summing out to 2.5 occurrence points when they needed to remain zero through their transition.
NERD!
You know it
If you add the 2.5 in cell J26 you can Use the IF function.
