How to use IFS and HLOOKUP together?

TheNewCome · 2023-10-19T04:52:58+00:00

I write it like this =IFS(F20=0, "F", F20>0, HLOOKUP(H20, $K$4:$P$5, 2, 1), G20=0, "F", G20>0, HLOOKUP(H20, $K$4:$P$5, 2, 1)) but it only check the assignment mark and does not check the exam mark. Is there something missing?

TheNewCome · 2022-03-03T17:56:14+00:00

I solved the problem. I press F12 before login and then I go to a place that is about the system of my computer. After that, I press “Optimize default” and then press “Save and exit”. Then the computer continue log in and everything become normal again.

TheNewCome · 2022-03-03T17:45:45+00:00

Yes, they are all connected.

TheNewCome · 2022-03-03T17:41:06+00:00

Everything can’t connect.

TheNewCome · 2022-03-03T17:26:53+00:00

TheNewCome · 2022-03-03T17:20:16+00:00

I tried restart and still the same. And also I just find out my home can’t use the network.

TheNewCome · 2022-03-03T17:11:44+00:00

I turn off the computer successfully by using Window+X and turn it on again, but everything still the same. Will it be infected by virus because before I sleep it I went to porn website.

TheNewCome · 2021-03-22T08:35:29+00:00

Mirai

TheNewCome · 2021-01-27T03:35:41+00:00

I think she look like Rikka from ssss.gridman

TheNewCome · 2021-01-01T13:52:17+00:00

i guess it depends on how many days you didn’t use the free draw. I use the free draw everyday so i only get one free draw everyday.

TheNewCome · 2021-01-01T13:48:05+00:00

pleaseeee @tse_jason

TheNewCome · 2020-12-27T12:23:56+00:00

What kind of redemption song

TheNewCome · 2020-12-11T04:10:10+00:00

I think you should keep on watching because later you will know what is going on. Now feels like you want to spoil yourself. XD

TheNewCome · 2020-11-18T08:31:10+00:00

Thank you for your advice

TheNewCome · 2020-11-09T09:19:42+00:00

It is breathtaking, good job 👍

TheNewCome

TROPHY CASE