Excel Formula

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

2 thoughts on “Excel Formula

  1. Dinesh Kumawat

    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”))

  2. Dinesh Kumawat

    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”))

Leave a Reply

Your email address will not be published. Required fields are marked *