RE: Multiple conditions
- From: "bj" <bj@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 13 Jul 2005 07:56:16 -0700
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 enter
=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
> 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
>
>
.
- References:
- Multiple conditions
- From: cruzin
- RE: Multiple conditions
- From: bj
- RE: Multiple conditions
- From: cruzin
- Multiple conditions
- Prev by Date: More Multiple conditions
- Next by Date: How can you jump to a selection in a validation drop-down?
- Previous by thread: RE: Multiple conditions
- Next by thread: cell validation even for values pasted into cells
- Index(es):
Relevant Pages
|
