Pop-Up Thingie
Sidebar
>>> Magnum BBS <<<
Home
Forum
Files
Dark
Log in
Username
Password
Sidebar
Forum
Usenet
MSOFT.PUB.EXCEL.WORKSHEET
How Do I Remove N/A Error from by formula
From
MyVeryOwnSelf
@21:1/5 to
All
on Tue Jul 16 10:06:21 2019
=RANK(B2,B$2:B$15,0)
My guess is that B2 doesn't contain an Excel number value, but instead contains an Excel text value that looks like a number.
One way to fix this is by wrapping it this way in B2:
=--(Whatever_is_in_B2_now)
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)
Who's Online
Recent Visitors
Michal Wronka
Wed Apr 24 14:13:57 2024
from
Wroclaw, Poland
via
SSH
Michal Wronka
Wed Apr 24 14:02:51 2024
from
Wroclaw, Poland
via
SSH
Guest
Wed Apr 24 01:40:10 2024
from
A
via
Telnet
Bob Worm
Thu Apr 25 11:52:12 2024
from
Wales, Uk
via
Telnet
System Info
Sysop:
Keyop
Location:
Huddersfield, West Yorkshire, UK
Users:
296
Nodes:
16 (
2
/
14
)
Uptime:
51:15:40
Calls:
6,649
Calls today:
1
Files:
12,200
Messages:
5,330,303