Easy Fix needed on Formula

[desibouy]

Hi,
I'm missing a bracket somewhere but God spent like 30mins behind it. I've tried everything in Notepad and Notepad++ tried changing the language to SQL and other formats to properly read it and find where I'm missing the bracket. I've tried adding but it still doesn't work.

Formula

=IF(AND(F4="CA",ISNUMBER(SEARCH("incontinence",U4))),ROUNDUP(FE4/0.66+6.95,0)-0.01,
IF(AND(F4="PK",ISNUMBER(SEARCH("incontinence",U4))),ROUNDUP(FE4/0.66+3,0)-0.01,
IF(AND(F4="BG",ISNUMBER(SEARCH("incontinence",U4))),ROUNDUP(FE4/0.66+3,0)-0.01,
ROUNDUP(FE4/0.66,0)-0.01))),IF(ISNUMBER(SEARCH("NOVA",U4))),ROUNDUP(FE4/0.66+15,0)-0.01,IF(FH4=13,ROUNDUP(FE4/0.66+13,0)-0.01,IF(AND(FH4=6.95,(FE4/0.66)<50),
ROUNDUP(FE4/0.66+3,0)-0.01,ROUNDUP(FE4/0.66+6.95,0)-0.01)))

Can someone help me please? I might need to add more at the bottom so if you can future proof it or show me how.
I'll need to add this statement again sometime in the future --

IF(ISNUMBER(SEARCH("NOVA",U4))),ROUNDUP(FE4/0.66+15,0)-0.01

Thank you

 

[AliGW]

There would seem to be an IF statement missing before the fourth ROUNDUP statement.

 

[desibouy]

There would seem to be an IF statement missing before the fourth ROUNDUP statement.

I don't see anything wrong. If I use the code without the rest then it works.

=IF(ISNUMBER(SEARCH("NOVA",U4))),ROUNDUP(FE4/0.66+15,0)-0.01,IF(FH4=13,ROUNDUP(FE4/0.66+13,0)-0.01,IF(AND(FH4=6.95,(FE4/0.66)<50),
ROUNDUP(FE4/0.66+3,0)-0.01,ROUNDUP(FE4/0.66+6.95,0)-0.01)))

 

[admiral100]

Hi,

Try this:

=IF(ISNUMBER(SEARCH("incontinence",U4)),IF(F4="CA",ROUNDUP(FE4/0.66+6.95,0)-0.01,IF(OR(F4="PK",F4="BG"),ROUNDUP(FE4/0.66+3,0)-0.01,ROUNDUP(FE4/0.66,0)-0.01)),IF(ISNUMBER(SEARCH("NOVA",U4)),ROUNDUP(FE4/0.66+15,0)-0.01,IF(FH4=13,ROUNDUP(FE4/0.66+13,0)-0.01,IF(AND(FH4=6.95,(FE4/0.66)<50),ROUNDUP(FE4/0.66+3,0)-0.01,ROUNDUP(FE4/0.66+6.95,0)-0.01))))