Hello everyone! Can someone help me with the formulas below? I have the first formula in cell GA4 and the second formula is right below it in cell GA5. For some reason it's giving a "0" no matter what number is in cell GA4. I've done this on numerous other columns and it worked perfectly, but now all of a sudden it's not. I think maybe it has to do with the ISBLANKS? It's the only difference I can see. I basically want it to read the number in GA4 and if it's between two other numbers on a tolerance tab, I want it to read 0. If it's not between those two numbers then I want it to perform the subtraction formula and report the difference.
Cell GA4 contains this formula: =IF(ISBLANK(Data!E1),"Removed",IF(AND(ISBLANK(Tolerances!$B$10),ISBLANK(Tolerances!$C$10)),"Removed",(COUNTIF(GA5:GA1000,"Yes"))))
Cell GA5 contains this formula: =IFERROR(IF(SEARCH("Removed",GA4,1),"Removed"),(IF(GA4>Tolerances!$C$10,(GA4-Tolerances!$C$10),IF(GA4<Tolerances!$B$10,(GA4-Tolerances!$B$10),"0"))))
Thanks for any help!
Cell GA4 contains this formula: =IF(ISBLANK(Data!E1),"Removed",IF(AND(ISBLANK(Tolerances!$B$10),ISBLANK(Tolerances!$C$10)),"Removed",(COUNTIF(GA5:GA1000,"Yes"))))
Cell GA5 contains this formula: =IFERROR(IF(SEARCH("Removed",GA4,1),"Removed"),(IF(GA4>Tolerances!$C$10,(GA4-Tolerances!$C$10),IF(GA4<Tolerances!$B$10,(GA4-Tolerances!$B$10),"0"))))
Thanks for any help!