Forum Discussion
Solved
IF AND function
Hello, I need help with a couple formulas. In one case, If cell $C18 and $X18 both have data, then apply the formula but if either is blank, then leave the cell with the formula blank. So this i...
Dennis, if with one column
=X3-IF(LEN(C3)=0,Y3,Z3)
Dennis, if with one column
=X3-IF(LEN(C3)=0,Y3,Z3)
Thanks for your help Sergie, your solution worked and 1 column is a much better option than having 2 different columns.
Dennis