Amend this formula?

[Mel Smith]

I have the following formula that works but I have found an issue if the referred cells are blank. How may the formula be amended if AN10 or AR10 is blank to show "" rather than a 0?

=IF('[ODC results.xlsm]Match 6'!$M$7="","",IF('[ODC results.xlsm]Match 6'!$AL$9="Warwickshire",'[ODC results.xlsm]Match 6'!$AN$10,'[ODC results.xlsm]Match 6'!$AR$10))

Thanks for your help.

Mel

 

[Special-K99]

Just place

IF(OR(AN10="",AR10=""),"",...) around the formula, like so

IF(OR(AN10="",AR10=""),"",IF('[ODC results.xlsm]Match 6'!$M$7="","",IF('[ODC results.xlsm]Match 6'!$AL$9="Warwickshire",'[ODC results.xlsm]Match 6'!$AN$10,'[ODC results.xlsm]Match 6'!$AR$10)))

This works because the SM$7 can return a blank also

 

[Mel Smith]

Perfect! Thank you Special-K99.

Mel