Multiple conditions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
=if(H26>=1500,if(m25=2000,0,2000),if(H26>=1050,if(M25=2000,0,2000),if(H26>=700,if(M25=3000,0,3000),if(H26>=525,if(M25=2000,0,2000),""))))
this leaves it blank if H26 < 525, change the "" to zero if that is your
"other" option
 
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!
 
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,2000),0)))
in M11 ente
=if(H11>=1500,if(Max(H$10:H11)>=1500,0,2000),if(H11>=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
 
Back
Top