Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Multiple conditions
I need to write a formla that has several conditions.
If H26=525 then a value of 2000 is entered in M26 but if M25 is 2000 then M26 needs to be 0 AND If h26= 700 then a value of 3000 is entered in M26 but if M25 is 3000 then M26 is 0 AND If h26= 1,050 then a value of 2000 is entered in M26 but if M25 is 2000 then M26 is 0 AND If h26= 1,500 then a value of 2000 is entered in M26 but if M25 is 2000 then M26 is 0 What I am trying to do is enter a value in Column M only once - and only when a specific number has been met. Thanks for your help! -- j |
#2
|
|||
|
|||
=if(H26=1500,if(m25=2000,0,2000),if(H26=1050,if( M25=2000,0,2000),if(H26=700,if(M25=3000,0,3000),i f(H26=525,if(M25=2000,0,2000),""))))
this leaves it blank if H26 < 525, change the "" to zero if that is your "other" option "cruzin" wrote: I need to write a formla that has several conditions. If H26=525 then a value of 2000 is entered in M26 but if M25 is 2000 then M26 needs to be 0 AND If h26= 700 then a value of 3000 is entered in M26 but if M25 is 3000 then M26 is 0 AND If h26= 1,050 then a value of 2000 is entered in M26 but if M25 is 2000 then M26 is 0 AND If h26= 1,500 then a value of 2000 is entered in M26 but if M25 is 2000 then M26 is 0 What I am trying to do is enter a value in Column M only once - and only when a specific number has been met. Thanks for your help! -- j |
#3
|
|||
|
|||
Thanks for responding. Your solution answered part of the question, but the
part that I can't figure out is this: Once the value of 525 has been reached it enters a value of 2000. On the next line it has to revert back to 0 until 700 has been reached where it enters a value of 3000. On the next line it reverts back to 0 until 1050 has been reached, etc. In other words the column that enters the value 2000, 3000, etc. can only enter that value once a certain objective has been met and can only enter that value once. example: 525 2000 600 0 650 0 700 3000 800 0 900 0 1000 0 1050 2000 thanks! -- j |
#4
|
|||
|
|||
A different way of doing it
if your H column data starts at say row 10 in M10 enter =if(H10=1050,2000),if(H26=700,3000,if(H26=525,2 000),0))) in M11 enter =if(H11=1500,if(Max(H$10:H11)=1500,0,2000),if(H1 1=1050,if(Max(H$10:H11)=1050,0,2000),if(H11=700 ,if(Max(H$10:H11)=700,0,3000),if(H11=525,if(Max( H$10:H11)=525,0,2000),"")))) and copy down Thanks for responding. Your solution answered part of the question, but the part that I can't figure out is this: Once the value of 525 has been reached it enters a value of 2000. On the next line it has to revert back to 0 until 700 has been reached where it enters a value of 3000. On the next line it reverts back to 0 until 1050 has been reached, etc. In other words the column that enters the value 2000, 3000, etc. can only enter that value once a certain objective has been met and can only enter that value once. example: 525 2000 600 0 650 0 700 3000 800 0 900 0 1000 0 1050 2000 thanks! -- j |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Sum and multiple conditions across different sheets | Excel Worksheet Functions | |||
Vlookup with multiple conditions | Excel Worksheet Functions | |||
SUM based on multiple conditions - SORRY, URGENT!!! | Excel Worksheet Functions | |||
How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions | |||
Sum If Multiple Conditions | Excel Worksheet Functions |