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),””,EDATE(B1,6)),(“”)),IF(A1=”PS”,(IF(ISBLANK(B1),””,EDATE(B1,8)),(“”)))
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),””,EDATE(B1,6)),(“”)),IF(A1=”PS”,(IF(ISBLANK(B1),””,EDATE(B1,8)),(“”))) Read More