=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. >
--------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
