Dear all,how to join two "IF" formula together ?
CELL U6 contains below formula (say results is 33)
IF(AND(B6>=20,C6>=13),SUM(B6:C6),0)
How to join below formula with first formula in the cell U6 together
IF(U6>79,"A+",IF(U6>69,"A", IF(U6>59,"A-",IF(U6>49,"B",IF(U6>39,"C",IF(U6>32,"D",IF(U6>0,"F","F")))))))
it will be something like below
IF(AND(B6>=20,C6>=13),SUM(B6:C6),0) IF(U6>79,"A+",IF(U6>69,"A", IF(U6>59,"A-",IF(U6>49,"B",IF(U6>39,"C",IF(U6>32,"D",IF(U6>0,"F","F")))))))
I will be happy if i get above issue solved by Macro also ( macro will be run from cell U6 to U1000 onwards )
Bookmarks