Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Help with my "if and" formulae and boolean values

Hi Guys,


Got an issue with a numbers spreadsheet that I'm making. It's a salary breakdown form for my workforce and I want to automate it as much as I can. One of the ways I am trying to do this is in regards to automatically calculating whether an employee has perfect attendance for a month in question.


How I do this is create a column for days taken off and a second column for whether perfect attendance is relevant to the employee in question as not all employees have this.


Now, if the first column has 0 (as in 0 days taken off) and the second column has "yes" (as in yes he is viable for perfect attendance) then he will automatically get an additional 200. My current formula is as such:


(if (and perfect attendance = yes, days taken off = 0),+200,+0)


The problem is that if the days taken off field is blank this also counts as 0 so the extra salary is given. Is there any way for the formula to only recognise the digit 0 as being true and not the blank field as well?


Thanks so much.

iPhone 7, iOS 10.2.1

Posted on Apr 23, 2018 5:12 AM

Reply
4 replies

There are no replies.

Help with my "if and" formulae and boolean values

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.