Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I leave formula cell blank if 2nd reference cell is empty?
example:
cell a1 had date, cell b1 WILL HAVE a date in it. cell c1 has formula=(a1+b1)+1. I'd like cell c1 to display empty until cell b1 has data in it. How do I do this? |
#2
|
|||
|
|||
How do I leave formula cell blank if 2nd reference cell is empty?
The formula in C1 would be
=IF(B1="","",A1+B1+1) |
#3
|
|||
|
|||
How do I leave formula cell blank if 2nd reference cell is empty?
=IF(B1="","",A1+B1+1)
-- Gary's Student "Liana S" wrote: example: cell a1 had date, cell b1 WILL HAVE a date in it. cell c1 has formula=(a1+b1)+1. I'd like cell c1 to display empty until cell b1 has data in it. How do I do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reference to One Cell stays the same in Different Formula | Excel Discussion (Misc queries) | |||
Empty Cell ( blank Cell ) | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Is there a way to go to next empty cell in a formula | Excel Worksheet Functions | |||
I there an easy way to find out if any formula reference a cell? | New Users to Excel |