| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
conditional formulas
I am having a difficult time with a particular function. Here is my formula
so far: =IF(OR(B2350000,B23<75000),7500+(B23-50000)*E8) My problem is that if the number is entered into B23 is 0, then the value in the formula cell is a negative number. What I want to have happen is that if a number is entered into B23 that does not fall between 50,000 and 75,000, the cell will read something like....NO CALCULATION AVAILABLE; TRY ANOTHER NUMBER, etc. Can someone help? Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can conditional formulas be used in or with pivot tables | Excel Worksheet Functions | |||
| Does a highlight row comand exist for Excel conditional formulas? | Excel Worksheet Functions | |||
| how can i use colors in conditional formulas if i want the result. | Excel Discussion (Misc queries) | |||
| How to create Multiple Conditional Formulas in a single cell? | Excel Discussion (Misc queries) | |||
| Conditional Formatting using result of Cell Formulas | Excel Discussion (Misc queries) | |||
Threaded Mode
