Hi,
looking for some help with a formula, I currently have the following:
=IF((AND( G3="Home", K3<-7)), "Road", IF((AND(G3="Home", K3>10)), "Home", IF((AND(G3="Road", K3<-3)), "Road", IF((AND(G3=Road, K3<14)), "Home"))))
No this works and gives me the results I want, however I want to have the text "None" if none of the criteria are met, value if false is you will. Can anyone help?
Thanks
David
Bookmarks