Thread: If Function
View Single Post
  #4   Report Post  
Jason Morin
 
Posts: n/a
Default

Sorry, the formula should be multiplied by C2.

=C2*CHOOSE(SUM(C2<1,C2<10,C2<=1000),0.01,0.02,0.03 2)

Jason

-----Original Message-----
An alternative to multiple IF functions:

=CHOOSE(SUM(C2<1,C2<10,C2<=1000),0.01,0.02,0.03 2)

HTH
Jason
Atlanta, GA

-----Original Message-----
If C2<1 then D2=c2*.032 If C2<10 then D2=C2*.02 If

C2<=1000 then D2=C2*.01
How would I do this?
.

.