IF(AND

Heath Sanders

In the attached sheet an error is showing in my IF(AND statement? [Current Month Sales]  shows $0.00 instead of a "" (Blank cell). Thanks in advance

 

<IFRAME WIDTH=1000 HEIGHT=700 FRAMEBORDER=0 SRC="https://app.smartsheet.com/b/publish?EQBCT=fccbf4d16b7442f9bd0160a985e4e494"></IFRAME>

Brett Evans

One of your parenthesis is off.  you need to move the ")" to from the end to right after "Heath Sanders".

 

The correct statement is.

=IF(AND([Invoiced Paid]2 = 1, [Sold By]2 = "Heath Sanders"), [Value of Jobs]2, "")

Heath Sanders

Thanks Brett, that work great.

 

You dont know how to return a blank cell instead of a $0.00 for the fomula below by any chance ?

 

=SUMIFS([Value of Jobs]2, [Sold By]2, "Heath Sanders", Status2, "WON", Result2, 1, [Sold Date]2, IFERROR(MONTH(@cell), "") = MONTH(TODAY()), [Sold Date]2, IFERROR(YEAR(@cell), "") = YEAR(TODAY()))

J. Craig Williams

=IF(SUMIFS([Value of Jobs]2, [Sold By]2, "Heath Sanders", Status2, "WON", Result2, 1, [Sold Date]2, IFERROR(MONTH(@cell), "") = MONTH(TODAY()), [Sold Date]2, IFERROR(YEAR(@cell), "") = YEAR(TODAY()))=0,"")

 

Craig