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.
Bookmarks