If Then forumal

  • Thread starter Thread starter DJ
  • Start date Start date
D

DJ

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
 
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
 
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.
 
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.
 
thanks fellas worked like a charm

JBoyer said:
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.
Click to expand...
 
Back
Top