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
|