| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Two Formulas in one cell
My goal is to have a cell that if a person enters 1500 or higher it uses this
formual: =(J19-N19)*50%*E19*65% and if they enter less then 1500 it uses this formula =(J19-N19)*50%*E19 does anyone know if this is possible? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CLICK CELL, GO TO ANOTHER CELL. NO FORMULAS. | Excel Discussion (Misc queries) | |||
| How to trace a cell? Which cells use a special cell in formulas? | Excel Discussion (Misc queries) | |||
| Formulas Using One Cell | Excel Discussion (Misc queries) | |||
| Copying formulas from cell to cell to cell to....... | Excel Discussion (Misc queries) | |||
| change cell value greater than another cell value using formulas | Excel Worksheet Functions | |||
Threaded Mode
