Subject: Microsoft excel help

Ok folks i have a problem :) I need a function that would write me the numbers from 0 to 4 in the cell for example A2, if that cell (A2) depends on the cell A1 like this:

(edited)

=IF(A2>75;0;IF(A2>45,01;4;IF(A2>40,01;3;IF(A2>35,01;2;IF(A2>30,01;1;IF(A2


For some reason is does not allow me to post entire formula, but I think you get the idea.
(edited)

you're my hero :D

than you...i tought it was IF but when i tried it i couldn't find of how to get the rid of TRUE/FALSE...or how to replace it with 1,2,3,4

thanks :D

Its not excatly Excel but its a computer issue.

I need to create two buttons in Flash. One that draws a rectangle and other one that draws circle( both have to have option to choose fill color)

Need help as soon as possible :(