'How can I combine two condition using IFS in google sheet to display particular data?
I would like to display 10 in a column if the PaymentStatus selected is Un Paid and Day selected is Friday. But If Day selected in Sunday, then display 5. I have tried below formula in Google sheet not working though, Can someone please advise on how can fix this one ?
=IFS((D4="Un Paid"),(F4="Friday"),10) OR ((D4="Un Paid"),(F4="Sunday"), 5) )
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|