Here are some problems that our users have asked and received explanations on
Hi, can you please help me with nested IF statement in Excel?
IF(A=1) else check next cell IF(B=1) else check next cell IF(C=1) then perform calculation.
Solved by C. C. in 19 mins
I need the formula that solves the following nested if for ATP:
If C18 = 0
then C19 = 0
Else If D18 = 0
Solved by D. J. in 30 mins
4. In Column E, enter a formula using a nested IF function to determine the number of vacation days based on the rules below:
15 days for full-time employees
10 days for part-time employees
0 days for everyone else
Solved by I. H. in 14 mins
I need formula to express: IF (23 > 0 AND 26 > (24+ 23), 26-23-24)
ELSE IF (23 <= 0 AND 26 > 24, 26 - 24) ELSE 0