If Then forumal
in [Functions]
|
Prev: How do I round a number to the nearest .49 in a cell that has
Next: How to convert data from Landscape to vertical
From: DJ on 2 Jul 2008 20:46 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
From: JBoyer on 2 Jul 2008 21:01 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
From: NoodNutt on 2 Jul 2008 21:04 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.
From: JBoyer on 2 Jul 2008 21:10 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
From: Teethless mama on 2 Jul 2008 21:20
=INDIRECT(LOOKUP(E4,{0.05,0.14,0.23},{"K7","L7","M7"})) "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 |