Combining Two If statements

Emily Reed

Hello!

I am trying to combine the following two if statements and every time I try, it gives me an error.

=IF(NOT(ISBLANK([Date Submitted to AP]2)), "Yellow")

=IF(NOT(ISBLANK([Fulfillment Receipt Received]3)), "Green")

Any help would be greatly appreciated!

Paul Newcome

Happy to help.👍️

Paul Newcome

Try something like this...

=IF([Date Submitted to AP]2 <> "", "Yellow", IF([Fulfillment Receipt Received]3 <> "", "Green"))

Emily Reed

Hello Paul!

I tried that and did not get an error, but it only recognizes the yellow if statement.

Emily Reed

Oh, I got it to work by flipping the colors -

=IF([Date Submitted to AP]2 <> "", "Green", IF([Fulfillment Receipt Received]3 <> "", "Yellow"))

Thank you so much!

Paul Newcome

Happy to help.👍️