The IF function in Excel can be nested, when you have multiple conditions to meet ... If cell A1 is greater than 10 and less or equal to 20, the function returns 700.
www.google.com.tw