Re: [libreoffice-users] IF doesn't respect AND?

Hi Hylton.
There is an ISBLANK() function that will test if the cell is blank. 
Safer might be to test IF UPPER($Data.F$3:F$1000)  NOT "Y"
Check the help on SUMFS also for multiple test criteria as you could 
test for ISBLANK(), is not "y", is not "Y"

Is there a reason you are not entering the dates as a date rather than a 
number.

Steve

On 28/09/2018 03:24, Hylton Conacher (ZR1HPC) wrote:
> I am using the formula of
>
> =IF(INT($Data.$A$3:$Data.$A$1000/100)=$A3,SUMIF($Data.F$3:F$1000,"N",$Data.C$3:C$1000),0) 
>
>
> This formula works but I would like to have a blank field i.e. "" 
> instead of "N".


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy