Nested IFs?

[Cuzzaa]

Hi everyone

I'm using the below code which works fine:

=IFERROR(IF(J29="As Required","Confirm Qty",J29*K29),)

But I'm trying to work out how to add another if statement into the above code at the end so that the following also happens:

If K29="Item Not Found" then ALSO in L29 print "Update List", otherwise J29*K29

Does that make sense, please could someone give me a hand? I've tried using the IFS statement and I can't get it to work properly

Thank you!

 

[Special-K99]

IF K29="Item Not found"

This is text, you cant multiply text as in J29*K29
You need to establish its not text FIRST.

so, maybe

=IFERROR(IF(J29="As Required","Confirm Qty",IF(K29="Item Not Found", "Update List", J29*K29)),)