Phylis Sophical
New Member
- Joined
- Jan 13, 2002
- Messages
- 42
In A1 to A5, I have blank cells that I will eventually insert values into. A6 contains the total of A1 to A5 example:=sum(A1:A5)
In B1 to B5, I want to divide the number in column A by
the total (A6)
formula is: =A1/A6 and so on.
The problem is that if I don't have a value in A1 to A5 yet, the the formula cells in column B show #DIV/0!
What can I put in that formula to make the B cells show nothing until there is a value in the A cells.
I have a small checkbook worksheet I got off that net that has something simular where nothing shows in the balance column until there is a date in the first column. It looks like this:
=IF(B35="","",(G34-E35+F35))
The double quotes and comma's have something to do with 'if there is not a date in the date column, don't show anything in the balance column. In other words, there is no entry there yet.
I know this is an awfully long explanation. I'm sure there is a fancy Excel word I am looking for, but that's the problem, I don't know what that's called. Can someone tell me what I need in that formula and what Excel calls it when you don't want anything to show in the formula column until there
is data entered that relates to the formula.
In B1 to B5, I want to divide the number in column A by
the total (A6)
formula is: =A1/A6 and so on.
The problem is that if I don't have a value in A1 to A5 yet, the the formula cells in column B show #DIV/0!
What can I put in that formula to make the B cells show nothing until there is a value in the A cells.
I have a small checkbook worksheet I got off that net that has something simular where nothing shows in the balance column until there is a date in the first column. It looks like this:
=IF(B35="","",(G34-E35+F35))
The double quotes and comma's have something to do with 'if there is not a date in the date column, don't show anything in the balance column. In other words, there is no entry there yet.
I know this is an awfully long explanation. I'm sure there is a fancy Excel word I am looking for, but that's the problem, I don't know what that's called. Can someone tell me what I need in that formula and what Excel calls it when you don't want anything to show in the formula column until there
is data entered that relates to the formula.