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.

MBoozer Wrote:
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

--
avveerka
-----------------------------------------------------------------------
avveerkar's Profile: http://www.excelforum.com/member.php...fo&userid=3033
View this thread: http://www.excelforum.com/showthread.php?threadid=51307