Hi,
Can someone please help me with my If statement (column M) in the attachment.
I have time format in column L. I need to compare this time against the values below
no. of P1 (column C) resolved <= 4.5h
no. of P2 (column C) resolved <= 9.5h
no. of P3 (column C) resolved <= 35h
no. of P4 (column C) resolved <= 70h
e.g. =IF(AND(C3="1",L3<4.5),"TRUE",IF(AND(C3=2,L3<9.5),"TRUE",IF(AND(C3="3",L3<35),"TRUE",IF(AND(C3=4,L3<70),"TRUE","FALSE"))))
Hi,
Your formula is not consistent.
With M3 you are testing C3 for the string values "1" or "3" and the numeric values 2 or 4.
Change your "1" & "3" to 1 & 3
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
For Eg
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks