Greater or Lesser Than Formula

[Guest]

The numerical data in cell A10 will be between 0 and 100. I want to enter a
formula in cell A50 that is based on the value in A10. However, the formula
will be vary depending on if A10 is <33% or >33%. Something like this:
IF A10 > 33% Then ((A10*0.35)/2000)
OR IF A10<33% Then ((A10*0.75)/50)

Any ideas on the syntax for such a formula? Thanks.

 

[avveerkar]

The numerical data in cell A10 will be between 0 and 100. I want t
enter a
formula in cell A50 that is based on the value in A10. However, th
formula
will be vary depending on if A10 is <33% or >33%. Something like this:
IF A10 > 33% Then ((A10*0.35)/2000)
OR IF A10<33% Then ((A10*0.75)/50)

Any ideas on the syntax for such a formula? Thanks.

formula for A50 could be

=IF(A10<0.33,(A10*0.35)/2000,(A10*0.75/50))

I assuming that A10 has 0.33 when you say 33%. If it is 33 or somethin
change the formula accordingly

A V Veerka