IF statement calculation problem

**stevow** · 11-23-2009, 05:52 AM

Hi

Thanks for any help with this formula problem.

The spreadsheet is set out as follows:

Column A - Description
Column B - Reserve (Number)
Column C - Lower (Number)
Column D - Pack Quant (Number)
Column E - =IF(B2-C2<D2,"1","CHECK") (Number)

The problem I have is the IF in column E.

The answer I need to display is if Reserve - Lower is less than PackQuant Then "1", if is between 1xPackQuant And 2xPackQuant Then "2", if is between 2xPackQuant And 3x PackQuant Then "3" and so on.

Any ideas???

Many thanks

**t_e_k** · 11-23-2009, 06:02 AM

In E2:

Please Login or Register  to view this content.

Maybe?

**stevow** · 11-23-2009, 07:03 AM

Many thanks! Worked a treat. I have never heard of the Roundown function before..

Thanks again

**t_e_k** · 11-23-2009, 11:05 AM

You're welcome. I didn't know whether Excel had a rounddown function either! But usually when I want Excel to have something, I look it up and find it does already exist.