Excel if function
Closed
Kral
-
Feb 18, 2010 at 09:06 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 18, 2010 at 09:23 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 18, 2010 at 09:23 AM
Hello,
Basically i've set up some conditionally formatted cells and i want an extra cell warning me of how many false cells i have.
i want a cell that says some thing like,
if number of false cells are greater that 2, then display "retake", if less than or equal to, then dislpay "safe".
is this possible?
cheers in advance.
Basically i've set up some conditionally formatted cells and i want an extra cell warning me of how many false cells i have.
i want a cell that says some thing like,
if number of false cells are greater that 2, then display "retake", if less than or equal to, then dislpay "safe".
is this possible?
cheers in advance.
Related:
- Excel if function
- Excel mod apk for pc - Download - Spreadsheets
- Accessor function c++ - Guide
- Gif in excel - Guide
- Kernel for excel - Download - Backup and recovery
- Number to words in excel - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 18, 2010 at 09:23 AM
Feb 18, 2010 at 09:23 AM
Have you looked into use of function countif ?