Hi Pat

an IF statement has only three parameters Test, True, False
you've tried for six
Test, True, False,Test,True,False

you can nest other IF statements within an IF statement in the following way
=IF(Test1,IF(Test2,True,False),IF(Test3,True,False ))
here there's a IF statement (test2) in the true bit of Test1 and other one
in the false bit of Test1

however, i'm not sure when you want the second IF evaluated - do you want it
evaluated IF B74=Char(252)
e.g.
=IF(B75=CHAR(252),IF(J740,K22="QS",J74),"")

(you also had 4 parameters in this IF statement so i've taken 1 out)

Cheers
JulieD


"Pat" wrote in message
...
There is nothing wrong with the following formula:
=IF(B75=CHAR(252),J75,"")

What I want to do is add another argument to the formula as follows:
=IF(B74=CHAR(252),J74,"",IF(J740,K22="QS"),0,J74) ))

Many thanks if you can be of help.
Pat