ExcelBanter - More Multiple conditions

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - More Multiple conditions (https://www.excelbanter.com/excel-worksheet-functions/35147-more-multiple-conditions.html)

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

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