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
|