Hi

I'm trying to use a Nested IF formula function and am having a few
troubles with it, I'm not sure if you can use the "IF(OR)/IF(AND)"
function in a formula with other IF statements as well?

Example:

Column 1 Column2 Column 3 Column 4 Column 5
0.43
795
751 5


What I want to do is say if columns 1&2 are less than 1, and if
columns 4 and 5 are blank, then say "invoices not sent" otherwise "ok"

For the 1st part I can try: =IF((B3+C4<1),"Invs not sent","Ok")

For the 2nd part: =IF(AND(E3="",F3=""),"Inv's not sent","Ok")

I would like to combine this, but if say like in the 3 row above there
is a number greater than 1 and a number in Column 4 or 5, I would like
to say "Ok"

Any Suggestions???

Thanks Guys

Pete