King Habibuu
Level 1 (4 points)
iWork

Q: formula IF=date

Hi, i had this formula unable to be use in numbers but in Excel can, Help!!!

 

ColumnDate casting%
1/a23/8/16=IF(Date casting >1,1,0)
1/b25/8/16=IF

MacBook Pro, OS X El Capitan (10.11.6)

Posted on Aug 23, 2016 6:25 AM

by King Habibuu,Solvedanswer
King Habibuu King Habibuu
Level 1 (4 points)
iWork
A:

Today out of the blue i'd found the solution for my formula needed, using ISBLANK to get True False,

true false.jpg

Then i use COUNTIF to count the FALSE and divide the quantities of column.

Now i got the percent of columns casted for reporting just by entering casting date.

true false percent.jpg

Seems like Numbers also can be like excel with a little effort.

Thanks and i hope this help you others out there,don't give up hope on Numbers.

Posted on Aug 26, 2016 3:40 PM

Close
King Habibuu

Q: formula IF=date

  • All replies
  • Helpful answers

  • by King Habibuu,

    King Habibuu King Habibuu Aug 23, 2016 7:03 AM in response to King Habibuu
    Level 1 (4 points)
    iWork
    Aug 23, 2016 7:03 AM in response to King Habibuu

    Still new to this and i'd missed the chance to edit the post, this is the spreadsheet i need the formula for.

    If anyone knows how to get red B2 to get % of all column is good. TQ

    formulaIF.jpg

  • by t quinn,

    t quinn t quinn Aug 23, 2016 7:23 AM in response to King Habibuu
    Level 5 (5,063 points)
    Mac OS X
    Aug 23, 2016 7:23 AM in response to King Habibuu

    Hi King Habitué,

     

    There is an approach.

    Screen Shot 2016-08-23 at 8.22.04 AM.png

    My formula is in the footer

     

    quinn

  • by King Habibuu,Solvedanswer

    King Habibuu King Habibuu Aug 26, 2016 3:40 PM in response to King Habibuu
    Level 1 (4 points)
    iWork
    Aug 26, 2016 3:40 PM in response to King Habibuu

    Today out of the blue i'd found the solution for my formula needed, using ISBLANK to get True False,

    true false.jpg

    Then i use COUNTIF to count the FALSE and divide the quantities of column.

    Now i got the percent of columns casted for reporting just by entering casting date.

    true false percent.jpg

    Seems like Numbers also can be like excel with a little effort.

    Thanks and i hope this help you others out there,don't give up hope on Numbers.