Joe you are correct, Thank you. It works even when A1 is empty On Wed, Jun 3, 2009 at 8:15 PM, JOE Conner <[email protected]> wrote:
> 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] >
