Backboards: 
Posts: 152
In response to "Noodle me this one spam and jax..." by Mel Profit

You're missing a value in your last nested IF. Here you go

=IF(J43="Paid",I3-F2,IF(J43="In-Process","Pending",IF(J43="Submitted","Awaiting AP",IF(ISBLANK(J43),"PENDING",""))))

Post a message   top
Replies are disabled on threads older than 7 days.