I don't know what happened with the formatting of my previous message.
Also a spurious extra comma crept in. It should be
=IF(condition1,value_if_1_true,IF(condition2,value _if_2_true,value_if_2_false))
--
David Biddulph

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
The syntax is
=IF(condition1,value_if_1_true,IF(condition2,value _if_2_true,,value_if_2_false))
Note that if the first condition is <=100 (I assume that the = is a
typo?),then you don't need to include 100 as part of the second
condition, as you wouldn't get there unless it were 100.

"janet" wrote in message
...
How do i create a condition based on another cell with more than two
possibilities?
i.e., column A shows the number of units, and in cell B i need to workout
the total price, but the unit price changes according to how many units
there are eg = 100 units, price = £100; 100<201 units, price = £200
(therefore(100*100) + (x*200)); =201 units, price = £300 (therefore
(100*100) +(100*200) + (x*300)
Thanks!