If statement help 1

[Legends77]

What I am needing to do is a "if and" statement. I.E.
=IF(D11="Waste Disposal",E11-M11-O11,IF(D11="Property Taxes"& A11="1105006",ROUND(+E11*G11,20)+20000,IF(D11="Depreciation" & A11="1105006",ROUND(+E11*G11,20)+54000,ROUND(+E11*G11,20))))

Without the "&" portion of each if it works great but really need the "and". Tried spelling out "and" but get formula errors.

Any help is greatly appreciated.

 

[GlennUK]

It's AND(case1,case1) syntax.

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[Legends77]

Thanks! This was driving me nuts and will help me out in other files as well!

 

[RRinTetons]

You might also want to look at the OR() function to fill that need when you bump into it.


-
Richard Ray
Jackson Hole Mountain Resort

 

[Legends77]

Is there any way to use this AND() or the OR() with a SUMIF statement?
current formula:
=SUMIF(PROD!$P:$P,$A22,PROD!$F:$F)/1000

What I need to do is
sumif(PROD!$P:$P,$A22 and PROD!$C:C$,$A$36,PROD!$F:$F)/1000
Tried:
sumif(And(PROD!$P:$P,$A22,PROD!$C:C$,$A$36),PROD!$F:$F)/1000
but receive an error and think it is because of all the ",'s" in the "AND" portion that is messing up the logic.

Therefore, I tried:
sumif(And(PROD!$P:$P=$A22,PROD!$C:C$=$A$36),PROD!$F:$F)/1000
but also receive an error and think this is beause I am not following a true "SUMIF"

Any suggestions?

 

[GlennUK]

What version of Excel are you using?

Cheers, Glenn.

Beauty is in the eye of the beerholder.