Home |
Search |
Today's Posts |
#1
|
|||
|
|||
More Multiple conditions
I need to write a formula 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 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: 300 0 400 0 525 2000 600 0 650 0 700 3000 800 0 900 0 1000 0 1050 2000 -- j |
#2
|
|||
|
|||
Hopefully this will get you started
=IF(H26=525,IF(M25=2000,0,2000),IF(H26=700,IF(M2 5=3000,0,3000),IF(H26=1050,IF(M25=2000,0,2000),IF (H26=1500,IF(M25=2000,0,2000),"not of these"))) best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "cruzin" wrote in message ... I need to write a formula 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 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: 300 0 400 0 525 2000 600 0 650 0 700 3000 800 0 900 0 1000 0 1050 2000 -- j |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Unique Records with multiple conditions | 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 |