# Need 3 "IF" in one formula

1. ## Need 3 "IF" in one formula

Attached is a file. This is what i have going so far....

O2 formula is correct

O11 Needs to have an "IF" added to add IF (J11) = gal

O8 - Needs to have an "IF" added to the formula to account for IF (J8) = 100/gal

Then after the above 2 formulas are fixed it need to combined them all so that the same formula is in all cells in Column O

Can you have 3 "IF" formulas in 1 formula???  Register To Reply

2. ## Re: Need 3 "IF" in one formula

yes you can a few IF statements nested

this is the main formula
=IF(J2=M2,H2*N2/L2,(H2*43.56)*N2/L2)

now what do you want to with the other IFs

O8
=SUM(N8/K8)*((H8/100)*K8)

what do you need to do for 100/gal

O11
=SUM(N11/K11)*(H11*K11)

=IF( J2= "1000/sqft" , IF(J2=M2,H2*N2/L2,(H2*43.56)*N2/L2) , IF( J2= "GAL", SUM(N8/K8)*((H8/100)*K8), etc etc

is that the sort of thing you wanted to do ?
have a IF based on thw contents of J2 and depending on content carry out different calculations ?  Register To Reply

3. ## Re: Need 3 "IF" in one formula

almost

So i need to base everything off of Column (J) and column (N)

IF 1000/sqft is in both columns i need this formula... H2*N2/L2
IF acre is in both columns i need this formula... H2*N2/L2
IF 1000/sqft is in Column (J) and acre in column (N) i need this formula.... (H2*43.56)*N2/L2
IF 100/gal is in Column (J) i need this formula... =SUM(N8/K8)*((H8/100)*K8)
IF gal is in Column (J) i need this formula.... =SUM(N11/K11)*(H11*K11)

But i am running into the issue have all this together into one formula to drag down the entire column of (O) and calculate correctly  Register To Reply

4. ## Re: Need 3 "IF" in one formula

Long Formula with nested IF function, just check the file

Azumi  Register To Reply

5. ## Re: Need 3 "IF" in one formula

Formula:  `Please Login or Register  to view this content.`  Register To Reply

6. ## Re: Need 3 "IF" in one formula

Thanks for providing the exact details, and I see @vlady has provided the If statement , so hopefully that now solves you request   Register To Reply

7. ## Re: Need 3 "IF" in one formula

thanks so much for your help  Register To Reply