 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / June 2007Two 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? Assuming that 1500 is input in E19 =if(E19<1500,(J19-N19)*50%*E19,=(J19-N19)*50%*E19*.65) > 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? remove the second = sign you could also use =(J19-N19)*0.5*E19*if(E19<1500,1,0.65) > Assuming that 1500 is input in E19 > [quoted text clipped - 3 lines] > > 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? 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 > Assuming that 1500 is input in E19 > [quoted text clipped - 3 lines] > > 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? =(J19-N19)*0.5*E19*if(J19<1500,1,0.65) > 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 [quoted text clipped - 6 lines] > > > 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? Yes, change e19<1500 to j19<1500. By the way Duke and BJ have good comments as well > 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 [quoted text clipped - 6 lines] > > > 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? 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 > Assuming that 1500 is input in E19 > [quoted text clipped - 3 lines] > > 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? In which cell is the number to be entered? Assuming it's E19: =(J19-N19)*50%*E19*(IF E19>=1500,0.65,1) _____________________________________________________________________ > 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? Off Topic Vasant, Great to see you back after a long absence.  SignatureRegards Roger Govier > In which cell is the number to be entered? > [quoted text clipped - 9 lines] >> uses this >> formula =(J19-N19)*50%*E19 does anyone know if this is possible? Thanks, Roger; hope to be contributing more. :-) ________________________________________________________________________ > Off Topic > [quoted text clipped - 14 lines] >>> this >>> formula =(J19-N19)*50%*E19 does anyone know if this is possible? Assuming the cell they enter the value in is A1 Try =(J19-N19)*50%*E19*if(A1>=1500,65%,1) > 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? 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? > Assuming the cell they enter the value in is A1 > [quoted text clipped - 5 lines] > > 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? 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?] SignatureDavid Biddulph > 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 [quoted text clipped - 4 lines] > > Sorry to be a pain...does this help? >> Assuming the cell they enter the value in is A1 >> >> Try >> >> =(J19-N19)*50%*E19*if(A1>=1500,65%,1) >> > 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? 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) SignatureDavid Biddulph > 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 to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.