Hello Everyone I want to ask a question relating excel 2013. I have 2 columns A and B respectively.Now my question is that suppose there are 2 vaues. In column A it is 15 and in column B it is 25.Kindly provide a formula which output “A” if sum of column A and B is greater than 30. If it is less than 30 then it should print “B”. Moreover if one of the column (A or B) is blank i.e. there is no value in it then excel should print “C”.

Hope you understand my question. If not kindly let me know. Please Reply as soon as possible and Thanks in advance…

By: Raffay

Supose that you have values in cell A1 and B1 then the formula is for solve your question

=IF((A1+B1)>30,”A”,IF((A1+B1)=0,””,”B”))

Supose that you have values in cell A1 and B1 then the formula is for solve your question

=IF((A1+B1)>30,”A”,IF((A1+B1)=0,”C”,”B”))