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,
for your first question try:
=IF(COUNT(C18,X18)=2,X18-Z18,"")
Your second question is not complete. What if C18 and X18 both have data?