Thread
:
Multiple ifs
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
ab3d4u[_23_]
external usenet poster
Posts: 1
Multiple ifs
Gord Dibben;2516772 Wrote:
=LOOKUP(B2,{100,101.25,110},{125,128.45,135}) entered in C2
Could there be any other possibile values in column B?
If so, how would you want to deal with those?
Gord Dibben MS Excel MVP
On Thu, 6 Dec 2007 17:50:34 +0000, ab3d4u
wrote:
-
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.-
Thanks Gord, It worked just fine as I did not had any thing in col B.
--
ab3d4u
Reply With Quote
ab3d4u[_23_]
View Public Profile
Find all posts by ab3d4u[_23_]