Simple One

[Liverpool59]

I want to enter dolar values in column "B". B2 has my starting value. Each time I want to calculate say B5/B2 and in C5 show a dollar gain or loss, and in D5 show the percentage comparing to the starting value.

The formula I want for columns C & D is easy, except I want no answer in B has no value.

Here is what I want.... C5=B5-B2 if B5 is greater than or show zero, and I want the same for D5=B5/B2 only if B5 is greater tan zero


Start - Dec 19, 2006 $22,627.32
18-Jul-07 $24,128.53 $1,501.21 106.63%
-$24,128.53 0.00%
$0.00 #DIV/0!
$0.00 #DIV/0!
$0.00 #DIV/0!
$0.00 #DIV/0!
$0.00 #DIV/0!

 

[Joe4]

In D5, if you have =B5/B2, but only want it to calculate if B2>0, then use an IF formula, i.e.

=IF(B2>0,B5/B2,"")

Same logic can be applied to the other formulas.

 

[Liverpool59]

I like the formula. It works. But when I copy down.... I want the "B2" to stay constant

 

[Smitty]

Since it's a bit late for Joe to chime in (wrong time zone)...Check out Absolute References in the helpfile:

=IF($B$2>0,B5/$B$2,"")

HTH,

Smitty