destiny4adams
New Member
- Joined
- Jul 4, 2023
- Messages
- 14
- Office Version
- 2016
- Platform
- Windows
The formula I am using is not calculating correctly. What am I doing wrong?
=IF(C5=0,"",IF(C5>0,SUM(C5-20),IF(A5="*Nov*",A5="*Dec*",A5="*Jan*",A5="*Feb*",SUM(C5-98))))
What I am looking for is, if cell C5=0 then leave blank, if cell C5>0 then subtract 20 from cell C5, and if cell A5 contains Nov subtract 98 from C5.
The results I am looking for are:
I need cell G (How many days over) to calculate how many days Shawn worked over his contract days, which is, 20 days at work, 10 off, except during Nov-Feb then it is 98 days at work, 0 days off.
I need cell O (How many days under) to calculate how many days less than Shawn's contract is for being off work.
I tried to open the XL2BB, so I could upload my sheet, but I keep getting an error saying it cannot open in protected view (my workbook is not protected).
=IF(C5=0,"",IF(C5>0,SUM(C5-20),IF(A5="*Nov*",A5="*Dec*",A5="*Jan*",A5="*Feb*",SUM(C5-98))))
What I am looking for is, if cell C5=0 then leave blank, if cell C5>0 then subtract 20 from cell C5, and if cell A5 contains Nov subtract 98 from C5.
The results I am looking for are:
I need cell G (How many days over) to calculate how many days Shawn worked over his contract days, which is, 20 days at work, 10 off, except during Nov-Feb then it is 98 days at work, 0 days off.
I need cell O (How many days under) to calculate how many days less than Shawn's contract is for being off work.
I tried to open the XL2BB, so I could upload my sheet, but I keep getting an error saying it cannot open in protected view (my workbook is not protected).