Mar 31 2022 06:12 PM
=IF(E3>=0.02,"0",SUMIF(E3:E3,"<.02",J3:M3))
I am trying to write a formula for cell H3. It needs to show the sum of J3+K3+L3+M3 unless E3 is greater than or equal to 2%, then the answer needs to be zero.
This formula is working to show a zero regardless if E3 is greater or less than 2.
Any help would be greatly appreciated.
Mar 31 2022 06:32 PM
SolutionMar 31 2022 06:35 PM
Mar 31 2022 06:39 PM
Mar 31 2022 06:42 PM
Mar 31 2022 06:32 PM
Solution