Filling one cell only if another is filled

[LinaK]

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

 

[Roger Govier]

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.

 

[LinaK]

* =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