How can I combine two condition using IFS in google sheet to display particular data?-CodePudding

Home > Net > How can I combine two condition using IFS in google sheet to display particular data?

How can I combine two condition using IFS in google sheet to display particular data?

Time：02-24

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) )

CodePudding user response：

=ifs(and(D4="Un Paid",F4="Friday"),10,and(D4="Un Paid",F4="Sunday"),5,1,)

Page link：https//www.codepudding.com/net/313609.html

Prev:IF Statement Not Accepting Parameters - Spreadsheets

Next:HTML- Is there anything I can do to make my sticky navbar to work?

Tags：

google-sheets

google-sheets-formula

Links：
CodePudding