MrExcel Publishing
Your One Stop for Excel Tips & Solutions

between functions


Posted by Matt on November 27, 2000 11:26 AM

How can I creat a function saying that if a total is between 16825 and 33648 than it should subtract 16824


Posted by greg on November 27, 2000 12:48 PM

Response:

=if(and(a1>=16825,a1<=33648),a1-16824,) This formula presumes that the number you are looking at is in a1. It is if a1 is >= 16825 and a1 is <= 33648 then subtract 16824 from a1, else do nothing. That should work for you.