Please help with function
i tried getting help at a different forum but was treated like crap, and no body would help me. So, ive come here because everyone seems nice and knowledgeable.
Im trying to make it so: if 15 is entered in cell A1 then show 2 in cell A3, if 16 is entered into cell A1 then show 3 in cell A3, if 17 is entered into cell A1 then show 4 in cell A3 etc... and if the number is less than 15 show 0.
i've tried just about everything and nothing works, i usually get the #NAME? error. can someone please help me out here, i would be eternally grateful. thank you.