Forum Discussion
Issues with IFs And Formula
I have been Trying to get the correct formula for Hours and keep getting a False Error when I add the true and false out put in.
Unfortunately, those images don't show the entire formula that you've been entering. Can you describe more completely the references in your spreadsheet, what your logical tests are, and the desired results. Even better, could you also post a copy of the spreadsheet itself (so long as there's no proprietary or confidential info in it)...you can do that in Google Sheets or on OneDrive. Then grant us "edit" rights.
https://crownlinen-my.sharepoint.com/:x:/g/personal/hrubes_crownlinen_net/EWpUB3ZQ1ztBtWHfoWLtn3wBcLYIIvZ4sJjUSsHmeaaMSA?e=DKzjvmmathetes
- I looked at the sheet and added 2 formulas. You are getting a #N/A because the IFS statement has nothing to return because the condition is false so it tries to go to the 'next' condition and there is none. So in the 1st case I just added a "default" case by adding a condition TRUE (and hence always true) and the 'default' output. In the second case I replaced the AND with a product (*) since product of booleans is the same as an AND. Using product will return an array while AND will try to AND everything together. Sort of like the difference between A1:A3 + B1:B3 will give an array of 3 values while SUM(A1:A3,B1:B3) will return 1 value with all 6 values added together. I know you tested it with IF() and it works differently and that is another thing about how IF() and IFS() are different. IFS is like a function while IF is an operator (unless arrays are passed). So IFS evaluates all the parts of it and passes them into the function but IF will eval the condition and then eval the corresponding result. I know it is all very confusing but I hope my options help you.
- What I am Trying to Accomplish is a Delivery Window report From a Daily to a whole month. I will have daily tabs Pasting data from our GPS and inputting this in to the daily spreadsheet. This will then tell me if we were early, on time, or late.
What I am trying to do next is combine this in to a Monthly report not every account goes daily so I was putting in a if formula to search for the account name and if it = that then next test is to see if they were early, on time or late. and place a letter in the box for that day.
