Excel forumula help

Delboy24

Hi,

Hopefully some of you Excel guru's can help me.

I have a number of tabs in a spreadsheet, with one particular column listing the date somethng was received (Column A1 eg.)

To save trawling through a number of tabs to check I want to make a summary sheet which returns the argument if a date is input then "yes", if no date is input then the argument returns a "no" on the summary sheet.

Hope all is clear, thanks in advance.

Del

Lokolo

=IF(A1="","no","yes)

Which means, if A1 is empty, print no, otherwise print yes.

jamesb1239

Delboy24 wrote: »

Hi,

Hopefully some of you Excel guru's can help me.

I have a number of tabs in a spreadsheet, with one particular column listing the date somethng was received (Column A1 eg.)

To save trawling through a number of tabs to check I want to make a summary sheet which returns the argument if a date is input then "yes", if no date is input then the argument returns a "no" on the summary sheet.

Hope all is clear, thanks in advance.

Del

=IF(Sheet1!A1>0,"Yes","No")

basically = IF there is anything other than a blank cell in Sheet1! Cell A1 then the value of the cell that you enter the formula in will equal Yes otherwise in all other scenarios it will equal No

Hope that helps

Delboy24

Thanks very much - big help...