Formula error

		Microsoft Office Forums > Microsoft Excel > Excel
Formula error

FAQ

Thread Tools

Display Modes

09-12-2022, 02:05 AM

Marcia

Windows 11 Formula error

Office 2021

Expert

Join Date: May 2018

Location: Philippines

Posts: 551

How about this:
=IF(AND(P2=0,R2>="CANCELLED"),"CANCELLED",IF(I2<1, " ",IF(P2=0,"OUTSTANDING",IF(AND(P2<I2,R2>="CANCELLE D"),"PARTIAL ISS REMAINING QTY CNX",IF(P2=I2,"COMPLETE","PARTIAL")))))

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Cell formula error?	PomDave	Excel	9	10-29-2020 05:43 AM
LOOKUP Formula error but WHY???	Haga	Excel	1	04-17-2019 11:13 PM
Array formula value not available error for one result	emarkona	Excel	1	03-08-2018 03:00 PM
Error handling in formula - suppress 'Syntax Error'	Cosmo	Word	7	02-24-2014 07:08 AM
formula divide by serio error	vthomeschoolmom	Excel	1	04-18-2012 02:29 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:18 PM.