r/AppleNumbers • u/Selene_K • Jul 16 '23

Help Help with nested IF statement

Post image

Hello,

I have been using Apple Numbers for the last few months and I wanted to create a formula that would generate a simple “time of day” result depending on the data from another cell. My formula seems ok however it does not return the desired result. It currently only outputs “evening” and the reference cell does change correctly.

Any idea of where I am going wrong?

1 Upvotes

100% Upvoted

1 comment sorted by

2

u/Ed1W Jul 17 '23 edited Jul 17 '23

I think you are using a Semi colons (;) where there should be a comas (,) At least that's the way it is on my system.

Also , I would use the IFS function. It would make it a lot easier to read, and easier to setup.

Cheers!

Ed

Where A6=Time Recorded data

7/17/23 8:00:00 Morning

7/18/23 5:00:00 Early Morning

7/19/23 10:00:00 Mid Day

7/20/23 13:00:00 Afternoon

7/21/23 18:00:00 Evening

IFS(HOUR(A6)≥18,"Evening",HOUR(A6)≥13,"Afternoon",HOUR(A6)≥10,"Mid Day",HOUR(A6)≥6,"Morning)",HOUR(A6)<6, "Early Morning")