Hi,

hoping someone can assist with an IF formula I am trying to write.

it goes;

= IF number between 1 & 3, then 1 *10%, IF number between 4 & 7, then 1 *20%, IF number between 8 & 10, then 1 * 30%


thanks, Nik