i cant figure out an if statement for a range of numbers
what i need is:
if HU$2*HU$23<50, display 3
if HU$2*HU$23>50, but less than 101, display 2.5
if HU$2*HU$23>100, but less than 201, display 1.75
if HU$2*HU$23>200, but less than 301, display 1.5
if HU$2*HU$23>300, but less than 401, display 1.25
if HU$2*HU$23>400, display 1.15
thank you for any help
Bookmarks