IF formula help

Occasional Visitor

I have a formula that I need assistance with please. This is the formula for the cell beneath 'Modifier'. I need to add a condition to the formula that will disregard the formula if the number in the cell below 'Reviews' is less than 4. I believe an 'AND', 'OR', or 'NOT' condition should solve this but I am unable to piece it together correctly.

=IF(H7<201,"0.0%",IF(H7<302,"1.0%",IF(H7<402,"1.5%",IF(H7<502,"1.75%","2.0%"))))

CP$/ROReviewsModifier
  0.0%
  0.0%
2 Replies

@michaelh1111 

You forgot to tell us which columns you show. H, I and J? If so, try

 

=IF(I7<4,"",IF(H7<201,"0.0%",IF(H7<302,1.0%,IF(H7<402,1.5%,IF(H7<502,1.75%,2.0%)))))

@michaelh1111 

As variant

=IF( I7 < 4, "", LOOKUP(H7, {0,201,302,402,502}, {0,1,1.5,1.75,2})/100 )