Thread: Multiple ifs
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ab3d4u[_22_] ab3d4u[_22_] is offline
external usenet poster
 
Posts: 1
Default Multiple ifs


Here is a quick one for you gurus. BTW thanks for your help in advance
I have three different (insurance options) values in a column that has
145 employees. I have a new rate that I have to replace. So I want a
formula that basically reads like this - if b2=100 change it to 125, if
it equals 101.25 then change it to 128.45 and last option would be if it
equals 110 then change it to 135. If I get the first row correct I will
then copy it down.




--
ab3d4u