Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet forumal help | Setting up and Configuration of Excel | |||
filling forumal by colums | Excel Discussion (Misc queries) | |||
How do I chang numbers to letters on Excell forumal bar? | Excel Discussion (Misc queries) | |||
forumal does not work | Excel Worksheet Functions |