CODEWITHSUNDEEP
if-statementgoogle-sheetsdrop-down-menugoogle-sheets-formuladropdown
Sean McCoy Weaver
Sean McCoy Weaver

Reputation: 11

Google Sheets, Trying to run a formula only if the value cells are greater than 0

Having trouble with the If/Then coding in Google Sheets.

I am tring to run this formula

=ROUND((((F2+(G2*1.25))+H2*0.5)+I2)/3.75)

But only if F2, G2, H2, and I2 are greater than 0.

I can't use the IF ISBLANK function because F2, G2, H2, and I2 are dropdowns and the null set is 0.

Upvotes: 1

Views: 40

Answers (1)

PatrickdC
PatrickdC

Reputation: 2486

Use AND inside the IF Function

The basic formula for your scenario should look like this:

IF(AND(F2>0, G2>0, H2>0, I2>0), <FORMULA>, 0)

Wherein the AND function checks if all of the values from F2, G2, H2, and I2 are greater than 0. The IF function will then process the data (just replace <FORMULA> with your desired formula) once all values are greater than 0.

Hence, your new formula should look like this:

IF(AND(F2>0,G2>0,H2>0,I2>0), ROUND((((F2+(G2*1.25))+H2*0.5)+I2)/3.75), 0)

Reference:

Upvotes: 1

Related Questions