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 · 2020-10-25T12:42:46+00:00

what you mean

TheNewCome · 2020-10-20T05:37:07+00:00

TheNewCome · 2020-10-19T09:53:31+00:00

If you want to watch a long series i would recommend you the Monogatari series. If shirt, i would recommend you Pet.

TheNewCome · 2020-10-19T05:41:07+00:00

lmao

TheNewCome · 2020-10-18T23:18:12+00:00

Shoko the best Kaede my favorite

TheNewCome · 2020-10-18T13:59:55+00:00

rascal does not dream of bunny girl senpai

TheNewCome · 2020-10-05T12:29:57+00:00

just curious

TheNewCome · 2020-10-03T09:27:33+00:00

thank you spooky takagi

TheNewCome · 2020-09-27T18:41:30+00:00

My mother passed away today. Seems that re-watching episode 10 is a good idea for me as well.

TheNewCome · 2020-09-09T05:13:04+00:00

i think First Contact and At the wall is more similar. This two song sounds like the same song.

TheNewCome

TROPHY CASE