Donate SIGN UP
Home > Technology > Excel

Excel

Avatar Image
Kerplunk | 11:46 Fri 07th Nov 2003 | Technology
2 Answers
Hi guys. In Excel what formula do I need to do the following: If 2 cells are empty then a third cell is also empty otherwise the third cell = a formula. EG. if A1 & B1 = empty, then C1 = empty otherwise C1=A2+A3
prev divx codec pack
  
next Nintendo/Super Nintendo
Gravatar

Answers

1 to 2 of 2rss feed

Best Answer

No best answer has yet been selected by Kerplunk. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Avatar Image Metaphysical
If I've got this right then the formula in C1 should be as follows:

=IF((AND(A1="",B1="")),"",A2+A3)

12:48 Fri 07th Nov 2003
Avatar Image Kerplunk
Question Author
Thank you very much.
13:29 Fri 07th Nov 2003

1 to 2 of 2rss feed

Do you know the answer?

Excel

Answer Question >>