IF formula needs 1 more possible outcome

[ExcelRoy]

Hi,

I am looking to add one more If to the following formula

=IFERROR(IF('Order Information'!AW16="","",IF('Order Information'!B16='Order Status'!AF16,"Received",IF(OR('Order Status'!AF16="",'Order Status'!AF16=0),"Ordered",IF('Order Status'!AF16<'Order Information'!B16,"Partially Received")))),"")

I need the response to be "Error, Please Check" if AF16>B16

I have been playing around but I seem to have too many arguments

Many thanks for any help

 

[Jonmo1]

Try

=IFERROR(IF('Order Information'!AF16>'Order Information'!B16,"Error, Please Check",IF('Order Information'!AW16="","",IF('Order Information'!B16='Order Status'!AF16,"Received",IF(OR('Order Status'!AF16="",'Order Status'!AF16=0),"Ordered",IF('Order Status'!AF16<'Order Information'!B16,"Partially Received"))))),"")

 

[ExcelRoy]

Hi Jonmo,

Many thanks for your help but this still shows FALSE

 

[Jonmo1]

If it's returning FALSE, it means NONE of the conditions are TRUE.

I'd recommend using the Formula Evaluation tool to observe the formula 1 step at a time.

 

[MrTeeny]

Have you tried wrapping your original formula within a simple IF , plus I'm assuming AF16 is on the Order Status sheet and B16 on the Order Information sheet, if not just amend the addresses in bold

=IF([B]'Order Status'!AF16>'Order Information'!B16[/B],"Error, Please Check",IFERROR(IF('Order Information'!AW16="","",IF('Order Information'!B16='Order Status'!AF16,"Received",IF(OR('Order Status'!AF16="",'Order Status'!AF16=0),"Ordered",IF('Order Status'!AF16<'Order Information'!B16,"Partially Received")))),""))

 

[ExcelRoy]

Hi Jonmo,

I got it working, many thanks I had entered the AF part wrong

Thanks very much for helping

 

[Jonmo1]

You're welcome.

FYI, highlighted RED below is where you would put some action if all conditions are false

=IFERROR(IF('Order Information'!AF16>'Order Information'!B16,"Error, Please Check",IF('Order Information'!AW16="","",IF('Order Information'!B16='Order Status'!AF16,"Received",IF(OR('Order Status'!AF16="",'Order Status'!AF16=0),"Ordered",IF('Order Status'!AF16<'Order Information'!B16,"Partially Received","AllConditionsFalse"))))),"")