Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |