software

I wish to write a formula such that the response would not be simply the
computed value but gt;value. It can't be done by simply changing the display
format of the cell since there are more than one IF commands. I wish to
incorporte it into the If command.

How much greater?

It's relatively simple to tack on an additional value to be added to the
return of a calculation.

=IF(quot;your formulaquot;) 'any number'
=IF(quot;your formulaquot;) 'any cell' ... where you enter a value in that
particular cell.
=MAX(IF(quot;your formulaquot;),'pre-determined maximum value')

Care to give some examples?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

quot;Kaputaquot; gt; wrote in message
...
gt; I wish to write a formula such that the response would not be simply the
gt; computed value but gt;value. It can't be done by simply changing the
display
gt; format of the cell since there are more than one IF commands. I wish to
gt; incorporte it into the If command.quot;Kaputaquot; wrote:
gt; I wish to write a formula such that the response
gt; would not be simply the computed value but gt;value.

Please give some examples of what you mean. Your
question cannot be as silly as it reads. For example,
a silly answer would be: always add 1 to the result.
Thus, the result is not simply the computed value, but
always something greater ;-).

I suspect you are interested in ROUNDUP(). However,
note that ROUNDUP() will be equal to the computed
value when the computed value is quot;exactquot; to the
specified precision. For example, ROUNDUP(1.0,0) is
1.0. Is that acceptable? If not, what result would you?