IF formula help

[michaelh1111]

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$/RO	Reviews	Modifier
		0.0%
		0.0%

[#2]

@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%)))))

[#3]

@michaelh1111 

As variant

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