Thread: formatting
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Totti Totti is offline
external usenet poster
 
Posts: 51
Default 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