Forum Discussion
Solved
Problem with an if formula
Trying to write an If formula. If cell A1 has A then formula A runs is cell C1. If Cell A1 has B then formula B runs in cell C1. This is what I tried but get an =IF(A1="UG",(IF(ISBLANK(B1),"",EDA...
Does this work?
=IF(A1="UG",(IF(ISBLANK(B1),"",EDATE(B1,6))),IF(A1="PS",(IF(ISBLANK(B1),"",EDATE(B1,8)))))
Does this work?
=IF(A1="UG",(IF(ISBLANK(B1),"",EDATE(B1,6))),IF(A1="PS",(IF(ISBLANK(B1),"",EDATE(B1,8)))))
So glad it worked! Gunnie