Forum Discussion
Solved
Nesting IF formulas in same cell
I'm not great at writing formulas and usually find answers on forums like this to help me. I'm trying to put two formulas in one cell. My issue: Goal 1. I want to only add two cells if they ...
- so you can simply insert that second formula in where K14 is in the first:
=IF(OR(ISBLANK(K14),ISBLANK(I14)), "", IF(I14>K14,K14+1,K14)-I14)
but here is another alternative:
=IF(OR(ISBLANK(K14),ISBLANK(I14)), "", (I14>K14)+K14-I14)
in this latter I just use the condition (I14>K14) which will convert to 0 (false) or 1 (true) because it is in the equation.
so you can simply insert that second formula in where K14 is in the first:
=IF(OR(ISBLANK(K14),ISBLANK(I14)), "", IF(I14>K14,K14+1,K14)-I14)
but here is another alternative:
=IF(OR(ISBLANK(K14),ISBLANK(I14)), "", (I14>K14)+K14-I14)
in this latter I just use the condition (I14>K14) which will convert to 0 (false) or 1 (true) because it is in the equation.
=IF(OR(ISBLANK(K14),ISBLANK(I14)), "", IF(I14>K14,K14+1,K14)-I14)
but here is another alternative:
=IF(OR(ISBLANK(K14),ISBLANK(I14)), "", (I14>K14)+K14-I14)
in this latter I just use the condition (I14>K14) which will convert to 0 (false) or 1 (true) because it is in the equation.
