LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default Excluding cell in formula

I have a worksheet as a result of customer surveys but the customer is
allowed to press * to skip he question or leave blank, how can I get the
percentage for the calls and exclude these numbers?

example

Driver protect come back overall
percentage

Paulo * 5
5 ?
Rolando 5 5 5
100%
Kane 5 5
?

How can I make this work?
Can anybody help me?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Array Formula Minimum Excluding Text Adams SC Excel Discussion (Misc queries) 5 March 8th 07 02:29 PM
how do i lookup the value of the next cell excluding the first lookedupresult MoronME Excel Worksheet Functions 3 April 20th 06 04:13 PM
Looking for formula for lowest costs, excluding zero Pipeladylu Excel Worksheet Functions 7 September 20th 05 10:42 PM
Formula - Excluding weekends & holidays Connie Martin Excel Worksheet Functions 9 February 25th 05 04:28 AM
excluding cells from the formula when empty Joe Shell Excel Worksheet Functions 5 November 21st 04 04:37 PM


All times are GMT +1. The time now is 06:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"