• MVP Logo
  • Recent Forum Posts

    Bob Phillips

    IF Formula

    Yeah, you specify "" for false condition, e.g.

    =IF(A2"",DATE(YEAR(A2)+10,MONTH(A2),DAY(A2)),"")...

    Bob Phillips Today, 12:58 AM Go to last post
    AndyDuncombe

    Worksheet named from cell

    this is truly incredible! In an ideal worls I'd like to use data validation to populate the names that show in column A...

    AndyDuncombe Yesterday, 08:58 PM Go to last post
    Jodie

    IF Formula

    Iím looking for help with a formula that will only do calculation based on if there is data in a cell. Example: ColumnA is an enrollment date but is...

    Jodie Yesterday, 08:11 PM Go to last post
    Bob Phillips

    Worksheet named from cell

    I have made that change. I named the sheets as ddd d mmm as it takes less space, is just as clear, and means you see more roster sheets at one time. Each...

    Bob Phillips Yesterday, 08:05 PM Go to last post
    AndyDuncombe

    Worksheet named from cell

    Which I'd like to rename as Sunday 2 Jan + sunday 9 Jan etc or whatever variant will fit. I think this would call from the app settings sheet data in...

    AndyDuncombe Yesterday, 06:27 PM Go to last post