Forum: >>> Magnum BBS <<<

Dark
Log in

Username Password

Re: Formula to identify decimal versus whole numbers

From Jennifer Yeh@21:1/5 to All on Thu Mar 9 19:17:17 2023

Re: formula to identify decimal versus whole numbers

I don't think anyone has offered this solution yet...
Assuming A1 contains the number you're trying to assess, use this formula: =if(round(A1)=round(A1,2),"integer","decimal")

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

Who's Online
Recent Visitors
- Guest
  Mon Jan 13 16:23:22 2025
  from /bin/busybox Cat /proc/self/ex via Raw
- Johnnyv
  Mon Jan 13 15:13:31 2025
  from Bilbao, Spain via Raw
- Guest
  Mon Jan 13 14:32:22 2025
  from /bin/busybox Cat /proc/self/ex via Raw
- Guest
  Mon Jan 13 14:02:16 2025
  from /bin/busybox Cat /proc/self/ex via Raw
- Keyop
  Mon Jan 13 10:51:30 2025
  from Huddersfield, West Yorkshire via SSH
- Guest
  Mon Jan 13 04:28:28 2025
  from /bin/busybox Cat /proc/self/ex via Raw
- Keyop
  Mon Jan 13 00:52:04 2025
  from Huddersfield, West Yorkshire via SSH
- Keyop
  Sun Jan 12 23:21:51 2025
  from Huddersfield, West Yorkshire via SSH

System Info

Sysop:	Keyop
Location:	Huddersfield, West Yorkshire, UK
Users:	399
Nodes:	16 (2 / 14)
Uptime:	59:51:30
Calls:	8,347
Calls today:	7
Files:	13,159
Messages:	5,893,326