What function should I use>

[Greg Bonaparte]

I would like a cell to calculate a formula in a cell only if certain criteria is met in a cell range. Otherwise I want the same cell to remain blank. EXAMPLE:

SUM "=$P30/$Q30" INSIDE OF CELL R30
IF "AC30>AB30 & AE30>AD30 & AG30>AF30 & AI30>AH30 & AK30>AJ30 & AM30>AL30 & F30>E30 & G30>F30 & H30>G30 & H30>I30"

OTHERWISE LEAVE CELL R30 BLANK

[#2]

Hi Greg,

Please update the formula in cell R30 as follows:

=IF(AND(AC30>AB30, AE30>AD30, AG30>AF30, AI30>AH30, AK30>AJ30, AM30>AL30, F30>E30, G30>F30, H30>G30, H30>I30),$P30/$Q30,"")

When all the below logical tests are true, the formula will divide the value of cell P30 on the value of cell Q30, otherwise, it will return a blank string.

AC30>AB30, AE30>AD30, AG30>AF30, AI30>AH30, AK30>AJ30, AM30>AL30, F30>E30, G30>F30, H30>G30, H30>I30

If you want at least one of them to be true in order to calculate, please use OR instead of AND

=IF(OR(AC30>AB30, AE30>AD30, AG30>AF30, AI30>AH30, AK30>AJ30, AM30>AL30, F30>E30, G30>F30, H30>G30, H30>I30),$P30/$Q30,"")

Hope that helps