series of if/else statements within an if/else statement

[Legacy 306954]

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

 

[Legacy 306954]

VBA Geek, I apologise. I told you 'c31, when it should have been D31. It now works. Thanks for your help.

 

[Snakehips]

Are you now fully sorted?

 

[Legacy 306954]

Yes thanks, except I now have to apply a currency conversion to the resulting number, but I think I can figure that out. Many thanks.