View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Docwhitley Docwhitley is offline
external usenet poster
 
Posts: 1
Default How do I set a value greater or less than

I am working on a spread sheet that will allow me to accurately keep track of
my commissions with the least amount of effort... and i am stuck on 1
formula... and I apologize if it is very basic but I am teaching myself this
software.

I want the sheet to look at the value of w5 and if it is between 20-24 I
want it to say 15 in w7 between 25 and 31 = 25 32 and 36 27.50

I hope that is enoungh information... if not let me know what else you need

Thanks
Will