Thread: IF
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tigger07 Tigger07 is offline
external usenet poster
 
Posts: 2
Default IF

=IF(G950<60000,1)+IF(G95060001<149999,2)+IF(G950 150000,3) this formula is
wrong and not sure what i need to do
I have a column with numbers ranging from 0-20000 and i need <60000 to pick
up 1, and between 60001-149999 to pick 2 and then 150000 to pick up 3
can anyone help
thank you