formatting
if you mean by format a formula that will be placed in B:B
then just put the following in B2
=IF((A2<200)*(A2100),A2*3,IF(A2<100,A2*2))
in case the value of your cell is < 0 or 200, you will need to alter
the "false" value of the if statement
|