Board 8 > I need Microsoft Excel help (Formula problem)

Topic List	Page List: 1
masterplum 04/15/12 7:42:00 PM #1:	I have this formula =IF(AND(B3>195, B3<554),"Cart Picking",????) The problem is the false statement. Is there something I can put there that will make the formula not change anything? I already used a variation of this to label a third of the cells or so, is there something I can do to make it so that it doesn't touch those instead of overwriting them? Thanks a ton -- yE frE me Kweku Ananse Papa me:http://img235.imageshack.us/img235/1508/masterplumgm3.jpg <cite>masterplum posted [p:1037566] in I need Mic... [t:62554270]...</cite> <quote> I have this formula =IF(AND(B3>195, B3<554),"Cart Picking",????)The problem is the false statement. Is there something I can put there that will make the formula not change anything? I already used a variation of this to label a third of the cells or so, is there something I can do to make it so that it doesn't touch those instead of overwriting them? Thanks a ton -- yE frE me Kweku Ananse Papa me:http://img235.imageshack.us/img235/1508/masterplumgm3.jpg </quote> ... Copied to Clipboard!
masterplum 04/15/12 7:49:00 PM #2:	Never mind, I just used nested if statements thanks though -- yE frE me Kweku Ananse Papa me:http://img235.imageshack.us/img235/1508/masterplumgm3.jpg <cite>masterplum posted [p:1037567] in I need Mic... [t:62554270]...</cite> <quote> Never mind, I just used nested if statementsthanks though -- yE frE me Kweku Ananse Papa me:http://img235.imageshack.us/img235/1508/masterplumgm3.jpg </quote> ... Copied to Clipboard!
Topic List	Page List: 1