Hi Friends
I want to create IF formula with the following conditions.
If cell A1 is less than 55,000,000, the answer should be NIL. If it is between 55,000,000 to 65,000,000, the A1 multiply by 2.50%, If it is between 65,000,000 to 75,000,000, then ((65,000,000 minus 55,000,000)*2.50% PLUS ((75,000,000 - Cell A1)*2.25%). If cell A1 is greater than 75,000,000, then ((65,000,000 minus 55,000,000)*2.50%) PLUS ((75,000,000 - Cell A1)*2.25%) PLUS ((Cell A1 - 75,000,000)*2.00%).
Thanks in advance
cheers
Bookmarks