Help with a budget formula?

[woobl]

Hi there,

First time poster but long time reader!

I am looking for a formula for a budget that deals with getting a total from an equation if a cell doesn't have any data. I would like to try and figure out the following:

Cell1 - No of People Cell2 - $Rate Cell3 - Weeks Cell4 - $Total

So if Cell1 and Cell2 are filled, but not cell 3 I get a total, and if Cell1xCell2xCell3 are filled, this also gives me a total in Cell4.

This is for a budget for a theatre production whereby these figures can be variable.

If anyone has any ideas I would be most grateful!

Thanks!

 

[CROY1985]

=IF(OR(C2=0,C2=""),A2*B2,A2*B2*C2)

try this in D2, where people are in a2, rate is in b2, weeks in c2.

 

[Roger Govier]

Hi

One way would be
=A2*B2*(MAX(1,C2))

where if cell 3 is blank, the formula uses 1 instead of 0, so that a value is returned, rather than it automatically making the value 0

 

[woobl]

Thanks so much! Works great! One thing, is there an option within the formula for D4 to be blank (i.e. no 0 figure) if the other cells aren't populated?

Thanks!

 

[Roger Govier]

Hi

Try
=IF(COUNT(A2:C2)<2,"",A2*B2*(MAX(1,C2)))