I just made my 1st "IF" formula. I am having trouble copying it the way I want it to. When I copy it changes things in it I don't want changed in that way.
Here is my formula:
=IF(B1>0,IF(B1<H2,"LOW",IF(B1<H6,"MEDSCH",IF(B1<H10"MED",IF(B1<H14,"HIGH","MAX")))),"")
Here is what I GET when I copy it:
=IF(B2>0,IF(B2<H3,"LOW",IF(B2<H7,"MEDSCH",IF(B2<H11,"MED",IF(B2<H15,"HIGH","MAX")))),"")
Here is what I WANT:
=IF(B2>0,IF(B2<I2,"LOW",IF(B2<I6,"MEDSCH",IF(B2<I10,"MED,IF(B2<I14,"HIGH","MAX")))),"")
I want the b column to shift down rows. I want the H column to shift right to next column.
Can this be done?
I don't want to write a different formula 365 times.
I appreciate any help you can offer.
This message was edited by Dolby51ex on 2002-09-19 01:46
This message was edited by Dolby51ex on 2002-09-19 01:54
Here is my formula:
=IF(B1>0,IF(B1<H2,"LOW",IF(B1<H6,"MEDSCH",IF(B1<H10"MED",IF(B1<H14,"HIGH","MAX")))),"")
Here is what I GET when I copy it:
=IF(B2>0,IF(B2<H3,"LOW",IF(B2<H7,"MEDSCH",IF(B2<H11,"MED",IF(B2<H15,"HIGH","MAX")))),"")
Here is what I WANT:
=IF(B2>0,IF(B2<I2,"LOW",IF(B2<I6,"MEDSCH",IF(B2<I10,"MED,IF(B2<I14,"HIGH","MAX")))),"")
I want the b column to shift down rows. I want the H column to shift right to next column.
Can this be done?
I don't want to write a different formula 365 times.
I appreciate any help you can offer.
This message was edited by Dolby51ex on 2002-09-19 01:46
This message was edited by Dolby51ex on 2002-09-19 01:54