Mark Knecht wrote:
=IFERROR(A1-90)
On Wed, Jun 3, 2009 at 6:55 PM, Walter Hildebrandt <[email protected]> wrote:
In A1 there can be any number from 1 through 100. In B1, how can I get the
difference between the A1 number and 90.
If the number in A1 is greater than 90, then the difference in B1 is a
positive number (For example if A1 is 91 then the number in B1 is 1. If the
number in A1 is 95 then the number in B1 is 5)
If the number in A1 is less than 90, then the difference in B1 is a negative
number (For example if A1 is 89 then the number in B1 is -1. If the number
in A1 is 88 then the number in B1 is -2. If the number in A1 is 10, then
the number in B1 is -80)
An additional requirement is if A1 is empty then B1 is empty.
Walter, use =IF(ISBLANK(A1);"";A1-90)
Joe Conner, Poulsbo, WA USA
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
