Filling one cell only if another is filled

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

LinaK - 28 Sep 2006 09:46 GMT

Bare with me if I don't get the terms right.. my excel isn't in
english :-)

I am in need of a funktion, which I am quite sure I have done
before... when the dinosaurs roamed, which is why I can't remember how
to do it now, sighing.

How do you make is so certain cells will only be filled, if some
others are filled first?

Example:
If these are the colums - name, address, sent, amount, price, postage
& total.
Price and postage are set to absolute references, and total is a
formula with amount*price+postage... and autofilled down the columns.
Not everyone is having stuff sent by mail, so if postage is showing
for all, then total will be incorrect. I want postage to show only if
I fill out the sent-cell for that row.

Can someone show me in the right direction, please?

Lina

Reply to this Message

Roger Govier - 28 Sep 2006 10:04 GMT

Hi

In cell F2 wrap your formula for determining postage, with an IF
statement

=IF(C2="",0,your_existing_formula)

then there will only be a postage figure if you have completed the Sent
column.

Signature

Regards

Roger Govier

> Bare with me if I don't get the terms right.. my excel isn't in
> english :-)
[quoted text clipped - 18 lines]
>
> Lina

Reply to this Message

LinaK - 28 Sep 2006 11:16 GMT

* =IF(C2="",0,your_existing_formula)

Got it to work.. had to exchange the , for ;

Then another problem occured.. grumbles.

Then I accounted another problem, but I fixed it by inserting another
IF function.

Thanks for the help :-)

Lina

Reply to this Message