L
Legacy 306954
Guest
Hi
Done my best to make this work and have failed. So would apppreciate some help.
excel 2007
I need this.. in excel talk:
if c61="THW", then if d31>=.05 but < 1.5, then d61=j40, else if d31>=1.5 but <2.5, d61=j41, else if d31>=2.5 but < 3.5, d61=j42, else if d31>=3.5 but < 4.5, d61=j43, else if d31>=4.5, d61=j44, [else if c61="Own", (user can enter own value in d61)]
Thanks for your help
David
Done my best to make this work and have failed. So would apppreciate some help.
excel 2007
I need this.. in excel talk:
if c61="THW", then if d31>=.05 but < 1.5, then d61=j40, else if d31>=1.5 but <2.5, d61=j41, else if d31>=2.5 but < 3.5, d61=j42, else if d31>=3.5 but < 4.5, d61=j43, else if d31>=4.5, d61=j44, [else if c61="Own", (user can enter own value in d61)]
Thanks for your help
David
Last edited by a moderator: