If Then forumal
 

Ok im really new to this and have been reading for hours. Heres what I'm
trying to do.

If E4=either.05, .14, .23 then B19=K7IF.05, L7IF.14, M7IF.23

hope that makes sense to someone thanks for any help given

If Then forumal
 

I think I know what you mean, try this in B19,
=IF(E4=0.05,"K71F.05",IF(E4=0.14,"L71F.14",IF(E4=0 .23,"M71.23","")))

-Jake

"DJ" wrote:

Ok im really new to this and have been reading for hours. Heres what I'm
trying to do.

If E4=either.05, .14, .23 then B19=K7IF.05, L7IF.14, M7IF.23

hope that makes sense to someone thanks for any help given

If Then forumal
 

G'day DJ

Here's a starting point for you, until someone comes up with a simplified
version.

Firstly, format E4 as Text, otherwise you will end up with ( K7IF0.05,
L7IF0.14 & M7IF0.23 )

this will do the trick

=IF(E4=".05","K7IF" & E4,IF(E4=".14","L7IF" & E4,IF(E4=".23","M7IF" &
E4,"")))

HTH
Mark.

If Then forumal
 

I was rereading your post and I think you want this
instead..=IF(E4=0.05,"K7",IF(E4=0.14,"L7",IF(E4=0. 23,"M7","")))

Sorry, and I hope this is what you need, let me know if it works for you.

"JBoyer" wrote:

I think I know what you mean, try this in B19,
=IF(E4=0.05,"K71F.05",IF(E4=0.14,"L71F.14",IF(E4=0 .23,"M71.23","")))

-Jake

"DJ" wrote:

Ok im really new to this and have been reading for hours. Heres what I'm
trying to do.

If E4=either.05, .14, .23 then B19=K7IF.05, L7IF.14, M7IF.23

hope that makes sense to someone thanks for any help given

If Then forumal
 

=INDIRECT(LOOKUP(E4,{0.05,0.14,0.23},{"K7","L7","M 7"}))


"DJ" wrote:

Ok im really new to this and have been reading for hours. Heres what I'm
trying to do.

If E4=either.05, .14, .23 then B19=K7IF.05, L7IF.14, M7IF.23

hope that makes sense to someone thanks for any help given

If Then forumal
 

thanks fellas worked like a charm

"JBoyer" wrote:

I was rereading your post and I think you want this
instead..=IF(E4=0.05,"K7",IF(E4=0.14,"L7",IF(E4=0. 23,"M7","")))

Sorry, and I hope this is what you need, let me know if it works for you.

"JBoyer" wrote:

I think I know what you mean, try this in B19,
=IF(E4=0.05,"K71F.05",IF(E4=0.14,"L71F.14",IF(E4=0 .23,"M71.23","")))

-Jake

"DJ" wrote:

Ok im really new to this and have been reading for hours. Heres what I'm
trying to do.

If E4=either.05, .14, .23 then B19=K7IF.05, L7IF.14, M7IF.23

hope that makes sense to someone thanks for any help given

If Then forumal
 

Another way...

=INDEX(K7:M7,MATCH(E4,{0.05,0.14,0.23}))


"DJ" wrote:

Ok im really new to this and have been reading for hours. Heres what I'm
trying to do.

If E4=either.05, .14, .23 then B19=K7IF.05, L7IF.14, M7IF.23

hope that makes sense to someone thanks for any help given

If Then forumal
 

Shorter version:

=LOOKUP(E4,{0.05,0.14,0.23},K7:M7)


"Teethless mama" wrote:

=INDIRECT(LOOKUP(E4,{0.05,0.14,0.23},{"K7","L7","M 7"}))


"DJ" wrote:

Ok im really new to this and have been reading for hours. Heres what I'm
trying to do.

If E4=either.05, .14, .23 then B19=K7IF.05, L7IF.14, M7IF.23

hope that makes sense to someone thanks for any help given