Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
=(J19-N19)*0.5*E19*if(J19<1500,1,0.65)
"Jim" wrote: Brad thank you so much. The 1500 number would be put in J19...E19 is for quantity whereas J19 if for price charged. Is that an easy change "Brad" wrote: Assuming that 1500 is input in E19 =if(E19<1500,(J19-N19)*50%*E19,=(J19-N19)*50%*E19*.65) "Jim" wrote: 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 | |
|
|
![]() |
||||
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 |