more than one criteria

[dreammaker]

Dear Helpers,

I need to evaluate some criteria, as example: B2 (some choices available ex: Total) C2 (date) D2 (number) E2 (date) F2 (some choices available ex: Approved)

in H2 to be evaluate first those previous fields validations to path and get the best description either ("Approved" or "Total" Or "Pending" etc..)

Best regards,

[etaf]

what are you rules for
"Approved" or "Total" Or "Pending" etc..

for example , in G2 you have approved - so is that what you want to use for H2
what condition would cells B2 to G2 be in , in order to get total or pending

and

we dont know what etc would be, so you need to define all the options