-2

I am looking for formula in which if I am multiplying Two columns like Column A and Column C (Column B is blank)and result is coming in Column D and i drag this formula for all row's below, and suppose if in next row Column A is blank and Column B is there than it should automatically multiple Column B with Column C to get result in Column D

closed as off-topic by Rob, Matthieu Riegler, grg, Ruskes, bmike Jun 11 '14 at 14:48

  • This question does not appear to be about Apple hardware or software within the scope defined in the help center.
If this question can be reworded to fit the rules in the help center, please edit the question.

  • 4
    This question appears to be off-topic because it is not about Apple products. – Rob Jun 11 '14 at 11:32
  • 1
    This question does not appear to be about Apple hardware or software within the scope defined in the help center. – grg Jun 11 '14 at 12:09
2

Try this (on D1):

=IF(ISBLANK(A1),B1,A1) * C1

Which check is A1 is empty, if so it makes B1*C1, if not then it makes A1*C1.

(As I'm not in an English version of Excel, the names may vary)

  • Its not working, can you please give me another formula or may be explain this one – bhavna Jun 11 '14 at 10:26
  • am using in english language and am using mac excel 2011 – bhavna Jun 11 '14 at 11:54
  • =ISBLANK(A1) is working and showing whether its true or flase – bhavna Jun 11 '14 at 12:06
  • but when i am using =IF(ISBLANK(A1);B1;A1) its showing that the formula i have type contains an error – bhavna Jun 11 '14 at 12:07
  • DO I HAVE TO PUT FORMULA LIKE THIS =IF(ISBLANK(A1),B1,A1)A1*C1 OR =IF(ISBLANK(A1),B1,A1)B1*C1 – bhavna Jun 11 '14 at 13:06

Not the answer you're looking for? Browse other questions tagged .