MS Excel Help

[hourn]

just need a bit of help here with a formula.

basically, what i want is a formula to calculate 75 - (a preceeding cell).

now some of the values are below 1, but i can' t have it so that the value is below 1. what formula do i put in so that if (75 - the cell) = 1 and in another row it equals -34 but in both cells the value from the formula is 1.

cheers

 

[jim boy]

=IF(75-A2<1,1,75-A2)

where a2 is the proceeding cell.

 

[hourn]

thanks mate

i nearly had it, i just had it in the wrong order.