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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Two Formulas in one cell
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Two Formulas in one cell
In which cell is the number to be entered?
Assuming it's E19: =(J19-N19)*50%*E19*(IF E19=1500,0.65,1) __________________________________________________ ___________________ "Jim" wrote in message ... 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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Two Formulas in one cell
Assuming the cell they enter the value in is A1
Try =(J19-N19)*50%*E19*if(A1=1500,65%,1) "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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Two Formulas in one cell
remove the second = sign
you could also use =(J19-N19)*0.5*E19*if(E19<1500,1,0.65) "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? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Two Formulas in one cell
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? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Two Formulas in one cell
You haven't said which cell your user will be putting the data into, but if
it were A19 try =(J19-N19)*50%*E19*IF(A19=1500,65%,1) -- David Biddulph "Jim" wrote in message ... 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? |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Two Formulas in one cell
Duke, thanks for your help. Unforunatly it is nt working.
The goal is to be able to type the sale price into J19. If that price is 1500 or greater I need the formula to then subtract 1500 from the total, divide it in half and deduct 35% from the total. If it is less then 1500 I need the same formula minus the 35% reduction. Sorry to be a pain...does this help? "Duke Carey" wrote: Assuming the cell they enter the value in is A1 Try =(J19-N19)*50%*E19*if(A1=1500,65%,1) "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? |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Two Formulas in one cell
=(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? |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Two Formulas in one cell
Yes, change e19<1500 to j19<1500.
By the way Duke and BJ have good comments as well "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? |
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Two Formulas in one cell
Thank you all...Brad's formula did it. And it was easily editable so I could
change minmum costs of different line items. Thank you Brad "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? |
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Two Formulas in one cell
So if the cell into which they enter the value, and which you wish to test
against 1500, is J19, not A1, what change do *you* think you should make to the formula =(J19-N19)*50%*E19*if(A1=1500,65%,1) ? And if the 1500 value is a variable stored in N19, what other change could you make? [If the value in N19 is 1500, I assume that you're happy that you'll be getting negative results when J19 is less than 1500?] -- David Biddulph "Jim" wrote in message ... Duke, thanks for your help. Unforunatly it is nt working. The goal is to be able to type the sale price into J19. If that price is 1500 or greater I need the formula to then subtract 1500 from the total, divide it in half and deduct 35% from the total. If it is less then 1500 I need the same formula minus the 35% reduction. Sorry to be a pain...does this help? "Duke Carey" wrote: Assuming the cell they enter the value in is A1 Try =(J19-N19)*50%*E19*if(A1=1500,65%,1) "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? |
#13
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Two Formulas in one cell
Off Topic
Vasant, Great to see you back after a long absence. -- Regards Roger Govier "Vasant Nanavati" <vasantn AT aol DOT com wrote in message ... In which cell is the number to be entered? Assuming it's E19: =(J19-N19)*50%*E19*(IF E19=1500,0.65,1) __________________________________________________ ___________________ "Jim" wrote in message ... 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? |
#14
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Two Formulas in one cell
Thanks, Roger; hope to be contributing more. :-)
__________________________________________________ ______________________ "Roger Govier" wrote in message ... Off Topic Vasant, Great to see you back after a long absence. -- Regards Roger Govier "Vasant Nanavati" <vasantn AT aol DOT com wrote in message ... In which cell is the number to be entered? Assuming it's E19: =(J19-N19)*50%*E19*(IF E19=1500,0.65,1) __________________________________________________ ___________________ "Jim" wrote in message ... 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? |
Reply |
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 |