round and ceiling

[nowfal]

Hi,

In cell A1, i have to choices, 'p' for purchase 's' for sale. In cel
D1 there is formula for ceiling as =CEILING(B1*C1,.05). that is exactl
suit for Sale purpose. But, it is not suit for purchase.
So, i would like to use ROUND(B1*C1/.05,0)*.05 for that. Is i
possible to give both formula in D1, if so how .

thanks in advance.
nowfa

 

[Freemini]

In cell D1 enter the following formula:

=IF(A1="S",CEILING(B1*C1,0.05),IF(A1="P",ROUND(B1*C1/0.05,0)*0.05,""))

hth

Mik

 

[JulieD]

Hi

yes
type in D1
=IF(A1="p",ROUND(B1*C1/.05,0)*.05,IF(A1="s",CEILING(B1*C1,.05),"Type p or s
in A1"))

Cheers
JulieD