LinkBack URL
About LinkBacks
Below are the AND statements:
=AND(A1>0.99,a1<1.08)
=AND(B1>1.07,B1<1.15)
I also want the answer to return "Green" for the first one and "Amber" for the second one
Below are the AND statements:
=AND(A1>0.99,a1<1.08)
=AND(B1>1.07,B1<1.15)
I also want the answer to return "Green" for the first one and "Amber" for the second one
Like this?
WBD
=IF(AND(A1>0.99,A1<1.08),"Green",IF(AND(B1>1.07,B1<1.15),"Amber",""))
Office 365 on Windows 11, looking for ✶ rep!
WBD,
Thank you so much. This works perfectly!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks