Hi,
I'm struggling here I'm sure the formula was working at one point and now I can't get it to work.
Basically if it's a CA and V11 contains Incontinence then KP11/.66 + 6.95
If it's PK or BG and V11 contains Incontinence then KP11/.66+3 otherwise any other item KP11/.66.
Thanks
I'm struggling here I'm sure the formula was working at one point and now I can't get it to work.
Code:
=
IF(AND(N11="CA",ISNUMBER(SEARCH("INCONTINENCE",V11))),ROUNDUP(KP11/0.66+6.95,0)-0.01,
IF(AND(N11="PK",ISNUMBER(SEARCH("INCONTINENCE",V11))),ROUNDUP(KP11/0.66+3,0)-0.01)),
IF(AND(N11="BG",ISNUMBER(SEARCH("INCONTINENCE",V11))),ROUNDUP(KP11/0.66+3,0)-0.01)),
ROUNDUP(KP11/0.66,0)-0.01
Basically if it's a CA and V11 contains Incontinence then KP11/.66 + 6.95
If it's PK or BG and V11 contains Incontinence then KP11/.66+3 otherwise any other item KP11/.66.
Thanks