Max,

Once again thank you for your time in assisting me.

What you have provided is perfect.

Regards

"Max" wrote:

Pank,

I re-looked at your numerical example
Try this set-up, it seems to return what you seek

In B25: =IF(A25<1,"","Normal Price")
In B26: =IF(B25="","",1)

In C25: =IF(A25<41,"","41-100 Price")
In C26: =IF(A25<41,"",IF(A25100,60,A25-40))

In D25: =IF(A25<101,"","100+ Price")
In D26: =IF(A25<101,"",A25-100)

If the above was helpful, take a moment to press the "Yes" button below to
the question: "Was this post helpful to you?" from where you're reading this.
It'll ensure a longer shelf life to this thread for the general benefit of
other readers.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---