

Thread Tools  Display Modes 
#1




Add 100 only if greater than 5200 (condition); Keep the same value between 2 values.
Hello!
Can somebody help me? I am back with the attached simplified excel table. I have to post the text with the modified cell names once again, because I deleted many columns and rows. I already have TWO formulas in two cells (columns), dependent on the same input cell, E7 Column 1) (result cell, J7) =IF(E7>=5200,MAX(150,ROUNDUP((E7200)/25,1))+100,MAX(150,ROUNDUP(E7/25,1 ))) I would like to upgrade this formula with the following conditions: * If 7450<E7<=8950, the result of cell J7 must remain fixed, remain the same, no longer increase proportionally, remain as at E7 = 7451. * If E7>8950, the value of J7 will increase proportionally again, where it left off, but by +50 instead of +100. ((J7200)/25,1))+50 Column 2) (result cell, L7) =IF(E7>=5200,MAX(150,ROUNDUP((E7200)/25,1)),MAX(150,ROUNDUP(E7/25,1)) ) I would like to upgrade this formula with the following conditions: * If 7450<E7<=8950, to the result of cell L7 add the value that is no longer added in J7 (because its value no longer increases) * If E7>8950, the value of L7 will increase proportionally again, where it left off, by +50. ((E7200)/25,1))+50 EXAMPLE; The E7 value is 7450; The J value (Column 1) will be 390 and the L value (Column 2) will be 290 The E7 value is 7451; The value of J (Column 1) will be 400 and the value of L (Column 2) will be 300 The value of E7 is 7800; The value of J (Column 1) will be 400 and the value of L (Column 2) will be 320 The value of E7 is 8000; The value of J (Column 1) will be 400 and the value of L (Column 2) will be 340 The value of E7 is 8300; The value of J (Column 1) will be 400 and the value of L (Column 2) will be 360 The value of E7 is 8500; The value of J (Column 1) will be 400 and the value of L (Column 2) will be 380 The value of E7 is 8800; The value of J (Column 1) will be 400 and the value of L (Column 2) will be 400 The value of E7 is 8950; The value of J (Column 1) will be 400 and the value of L (Column 2) will be 400 The value of E7 is 9000; The J value (Column 1) will be 410 and the L value (Column 2) will be 410 The value of E7 is 9300; The J value (Column 1) will be 420 and the L value (Column 2) will be 420 The value of E7 is 9500; The J value (Column 1) will be 430 and the L value (Column 2) will be 430 The value of E7 is 9800; The J value (Column 1) will be 440 and the L value (Column 2) will be 440 And so on... Thank you very much for your help! Copie simplificata  SIMULARE INSTRUMENTISTI EGAL  Google Sheets Last edited by rolysudest; 01242023 at 08:17 AM. Reason: I deleted many columns and rows from my excel table. 
#2




Cross posted at Add 100 only if greater than 5200 (condition); Keep the same value between 2 values.
and Add 100 only if greater than 5200 (condition); Keep the same until a value 2.  MrExcel Message Board Please add links to ALL cross posts ( as text if needed) and read A message to forum cross posters  Excelguru to understand why. Thanks
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post 
Thread Tools  
Display Modes  

Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
if greater than equal to  Kubi  Excel  2  02192018 01:45 PM 
How can I write if condition to get the values ...  LearnerExcel  Excel  3  12152016 03:10 AM 
How can I sum values using SumIfs condition like ...  LearnerExcel  Excel  6  11282016 09:45 PM 
outlook 2000 pst greater than 2gb  bbxrider  Outlook  0  09252010 02:37 PM 
If A1 greater than or equal to 1 Then A3 = A2*A1  brians  Excel  5  03092010 12:04 PM 