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.
