8th August 2005, 10:31 AM
|
|
Suspended. Invalid e-mail address.
|
|
Join Date: Jan 1970
Posts: 93
|
|
| A | B | C | D | E | F | | 1 | a | 4 | =IF(C1>0,1/C1,"") | =IF(C1>0,D1*($F$1/(100*$D$27)),"") | =IF((C1>0),"$"&(FIXED((1/E1),1)&"0"),"") | | 2 | b | 6.5 | =IF(C2>0,1/C2,"") | =IF(C2>0,D2*($F$1/(100*$D$27)),"") | =IF((C2>0),"$"&(FIXED((1/E2),1)&"0"),"") |
| | C | D | | | | 27 | | =SUM(D1:26) | =SUM(D1:26) |
|