| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Greater or Lesser Than Formula
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using greater than and lesser than formula | Excel Worksheet Functions | |||
| lesser than, greater than | Excel Discussion (Misc queries) | |||
| greater/lesser than | Excel Worksheet Functions | |||
| greater than or lesser than formulas | Excel Discussion (Misc queries) | |||
| if greater or lesser than | Excel Discussion (Misc queries) | |||
Threaded Mode
