This is totally not related to boats but I have looked everywhere and can't find the answer to this question. Im trying figure out how to make this if formula work in excel. I need to do an if statement where the logical test is if a value is between 0 and 20000, return a value. My problem is I don't know how to write it. I have tried this formula if(B15=1<20000,B15*.055,0). Im trying to say in my formula, if b15 is greater than 1 and less than 20000, multiply the number in b15 by .055, otherwise return a value of 0. My formula is not correct. How do I get the logical test to check for a value between 1 and 20000. Sorry for the spam but this is driving me nuts.