Thanks Problem Solved. I used Bernd's Formula and I was not referencing the
wrong cell as the cell D4 was on another sheet. Sorry about the confusion.
Really appreciate the help
--
Please help out a moderate excel user


"Conan Kelly" wrote:

Excel Confused,

HTH means "Hope This Helps".

This happens to me all the time: I see acronyms that I don't know what they
mean. I go to http://www.acronymfinder.com/ to see if they have the
meanings there.

Did any of these 3 solutions fix your problem?

Conan Kelly




"Excel Confused" wrote in message
...
What does HTH mean?
--
Please help out a moderate excel user


" wrote:

Hello,

Your approach:
=IF(D4<=50,2000,IF(D4<100,5000,10000))

HTH,
Bernd