regarding formulas

[BEATRIZ]

how do you enter two different formulas to apply to one cell? For example can I reference sheet one to sheet 2 but enter another formula so it rounds up the number in sheet one?

so if the number appears on sheet two as 322244000 how do i get it to appear on sheet one as 322.25 for example?
would the round up command do all that?

thanks

[BigBas]

Nest the functions. For example:

=ROUNDUP(IF(Sheet3!A1>0,Sheet3!A1,""),0)

[oldchippy]

You could try this,

=ROUND(Sheet2!A1,0)
or
=ROUNDUP(Sheet2!A1,0)
or
=ROUNDDOWN(Sheet2!A1,0)