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.


2 Replies


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




As variant

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