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