IF Formula

[Evie76]

Hi

I have a formula that works perfectly but instead of returning FALSE and would like to be blank. Can anyone please help

=IF(F7=0,MAX(INDEX((Append1[Compliance_Officer]=Sheet1!C7)*Append1[Date_Assessed],)))

Many thanks

 

[DanteAmor]

Try:

=IF(F7=0,MAX(INDEX((Append1[Compliance_Officer]=Sheet1!C7)*Append1[Date_Assessed],)),"")

 

[Peter_SSs]

Try
=IF(F7=0,MAX(INDEX((Append1[Compliance_Officer]=Sheet1!C7)*Append1[Date_Assessed],)),"")

BTW, what is the name of the sheet that this formula is on?

 

[Evie76]

The sheet is called combined

 

[Peter_SSs]

The sheet is called combined

Thanks. In that case the formulas suggested by Dante & myself above (Dante was slightly faster ) should be fine as posted. Hope they work for you.