View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sgibson sgibson is offline
external usenet poster
 
Posts: 1
Default How do I use 10<J3<20 in an IF Formula?

I am trying to use an IF function to calculate my commission. All I can get
it to do is if J3<20, but I need to get it to be 10<J3<20. It won't let me do
it. How can i get this to work?