How can I use the round up function after performing a formula?

[Guest]

example:

=F5-(F5*20%)ROUNDUP

 

[Guest]

Is that an Excel question, that you refer to a cell location F5, if so try
posting your question in Microsoft Excel Discussion group at this link

http://www.microsoft.com/office/com...?dg=microsoft.public.excel.misc&lang=en&cr=US

You have posted your question in Microsoft Access Discussion group

 

[Guest]

There is no roundup function in Access. This newsgroup is for Access, the
database product. I believe you want to post in the Excel news groups.
However, your syntax is incorrect. It should be
=F5 - ROUNDUP(F5*20%, ???)
??? = the ROUNDUP function requires a number of digits to round to. See
Excel Help for details

 

[SusanV]

And here I was thinking of a rodeo, rather than Excel...
<g>

 

[Guest]

Any more puns like that and I will report you for abuse