Hello

I would like a formula which will display certain price bands depending on what the value of a cell is.

I have column A titled "Average Unit Price" displaying the average unit price.

Column B is titled "Price band category", and depending on what value is in Column A, i would like column B to display the following price bands -

$0 - $99
$100 - $299
$300 - $499
$500+.

I have not achieved much despite spending some time on this and i am a little puzzled as to the best function to actually use?

I can only work out a small part of the formula which will only display the first price band category using a basic IF Statement as follows:

=IF(A1<=99,"$0 - $99","")

The above formula displays $0 - $99 if the average unit price in Column A is between the two numbers which is what i want, but how would i add the further price bands? every time I attempt this Excel shouts at me saying there are too many arguments.

Can anyone please offer assistance? what would be the best function to use? How can i add further arguments to an IF statement without making Excel angry? is it possible for 4 different outcomes to happen using IF statements?

Any help is massively appreciated.

Regards

Lewis