Ok, then adjust the numbers accordingly...
=($A1<>"")*(ISNUMBER($H1))*(($H1<-0.1)+($H1>0.1))
Ok, then adjust the numbers accordingly...
=($A1<>"")*(ISNUMBER($H1))*(($H1<-0.1)+($H1>0.1))
Regards, Zack Barresse
Check out the KB! :|: BOARD TAGS: WHAT ARE THEY AND HOW DO I USE THEM
What is a Microsoft MVP? | Free Microsoft Courses | My Book on Excel Tables
Posting Permissions
Reply With Quote