Windows 10: I'm trying to find the proper formula for figuring out the number of numbers in a cell, not...

Hello, if I have a cell with the numbers containing: 1,5,3,9,7,2 what formula would I use so that way I could see 6.

:)

 

Formula

hi Carlos

what application are you trying to add your formula to?

what happens if the number is equal to 45 (i.e. not larger no less than)?

as an example in excel (formula entered into cell A2)

=IF(A1>45,A1-45,A1+45)

when the number entered into cell A1 is greater than 45, 45 will be subtracted

when the number in cell A1 is equal to or less than 45, 45 is added.

=IF(A1>45,A1-45,IF(A1=45,45,A1+45))

when the number entered into cell A1 is greater than 45, 45 will be subtracted

when the number in cell A1 is equal to 45 it will remain as 45

when the number entered into cell A1 is less than 45, 45 is added.

 

Blocking Cell Phone Numbers

Here's one way to get around the problem. It's kludgy but it should work.

Get a VOIP based phone service or a magic jack. For 24/7 access, you're better off with VOIP that uses an ethernet adapter, but that's up to the user.

The important point is to find one that lets you create your own "black list" of callers. Usually they will have both black and white list options and these are usually a subcategory under the "do not disturb" or similar feature.

The provider will usually let you create a second number for $5-10 per month. You'll use this for your cell phone number. If it is ever compromised, you can change it easily without affecting the base number.

Forward the second number to your cell phone and give everyone that one as your "cell phone" number. There will be a delay of a few seconds as calls get routed, but who cares. It's not like any of us is on Obama's speed dial right?

Now when you get assholes calling you, just add them to the black list.

You can also block calls w/o caller id this way if your cell phone co. doesn't already do that for you.

 

average formula will not average

I can see three serious problems:

• The "IfError" function suppresses all errors in your formula. You must omit it while debugging the formula.
• You cannot use the "Search" function for a range of cells, only for strings.
• You are posting in the wrong forum (same as you did in January). For a formula as complex as this one you must go to a dedicated Excel forum. Remember to reveal the whole purpose of the formula when reposting instead of just casually throwing in the term
  "Average".
  
  Redirectingmsoffice_excel