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 youwouldn't get there unless it were 100.--David Biddulph"janet" wrote in do i create a condition based on another cell with more than twopossibilities?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 manyunits there areeg = 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!