I am having trouble nesting and using multiple criteria. I want a column to determine if payment type was CASH, CHECK or WAITING depending on if the cells for Check# and Payment are containing data.

I have attached my shared Google Sheets files here: https://docs.google.com/spreadsheets/d/1lG31qsy8s97OYnrBIK6k3RVR5s1UoxuqntFBJW3_b34/edit?usp=sharing

Any and all help is appreciated

1 Answer 1



  • This works!!! Now is there a way to expand on this, in order for CHECK to appear you have to have Data entered in both Check # and Payment columns, The other two seem to function as i was expecting but i would prefer as a bit of Error checking to have both cells entered in order for Payment type to display CHECK. Apr 12 at 3:33
  • As soon as you enter B2 Check number it changes result to CHECK, when i want it to be B2 AND C2 in order to output result of CHECK. I can use it as is, but i am curious how to achieve what i am looking for. Thank you! Apr 12 at 3:46
  • 1
    try: =IFs(and(B2="",C2=""),"WAITING",C2="","",and( B2<>"", C2>0),"CHECK",C2<>"","CASH")
    – Daniele
    Apr 12 at 3:55
  • 1
    Your AMAZING! exactly what i had been trying to get! I would have never been able to get this! Apr 12 at 4:15

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.