This is my formula: =IF(AND($C3<=1.875,$C3>1.75),$D3*F3,"")
The cell is blank if the logical test is FALSE. How can I get the $D3*F3 equation to round to nearest 10 and still have a blank cell if the logical test is FALSE.
I tried this equation: =ROUND(IF(AND($C3<=1.75,$C3>1.625),$D3*G3,""),-1)
which does round to the nearest 10 if the logical test is TRUE: but will not leave the cell blank if the logical test is FALSE.
Bookmarks