Noodle me this one spam and jax...
Posted by
Mel Profit (aka mel profit)
Apr 22 '15, 20:56
|
what if one of the options is a Blank?
Blank
Submitted
In-Process Paid
Not the word Blank but blank. I want it to say Pending.
I tried this, a Null Value and failed:
=IF(J43="Paid",I3-F2,IF(J43="In-Process","Pending",IF(J43="Submitted","Awaiting AP",IF(J43=”Null Value”,”Pending”))))
I also tried ISBLANK - all Google suggestions but nothing worked.
I have to go home. But it's fun to stretch like this a bit. It's the first time in weeks I haven't felt like a dog pushing a rock with it's nose.
|
Responses:
|