Author Topic: SQRT vs sqrt?  (Read 956 times)

0 Members and 1 Guest are viewing this topic.

Jennifer

  • Sr. Member
  • ****
  • Posts: 412
SQRT vs sqrt?
« on: July 27, 2020, 09:55:03 PM »
I started to enter a square root expression. I got as far as "=sqrt" and Visio offered me 4 choices:
  • sqrt
  • SQRT
  • SQRTPI
  • IMSQRT
I understand that SQRTPI and IMSQRT are different functions, but why do I get both a lowercase and an uppercase version? After entering each, they both convert to uppercase.
Using Visio 365 on Windows 10

Surrogate

  • Hero Member
  • *****
  • Posts: 1015
    • ShapeSheet™ Knowledge Base
Re: SQRT vs sqrt?
« Reply #1 on: July 27, 2020, 10:56:07 PM »
Hi, Jenifer!

You mean ShapeSheet function SQRT?
Where you find SQRTPI and IMSQRT?

You can write name of ShapeSheet function in lowercase or uppercase, Visio engine make it to uppercase. You can find same
behavior with MS Excel formulas!
« Last Edit: July 27, 2020, 11:06:43 PM by Surrogate »

Surrogate

  • Hero Member
  • *****
  • Posts: 1015
    • ShapeSheet™ Knowledge Base
Re: SQRT vs sqrt?
« Reply #2 on: July 27, 2020, 11:15:52 PM »
I started to enter a square root expression. I got as far as "=sqrt" and Visio offered me 4 choices
You get really especial Visio for 29$!

I find SQRTPI and IMSQRT in Excel's Worksheet functions. But can't find them for Visio

Jennifer

  • Sr. Member
  • ****
  • Posts: 412
Re: SQRT vs sqrt?
« Reply #3 on: July 28, 2020, 01:53:46 AM »
I started to enter a square root expression. I got as far as "=sqrt" and Visio offered me 4 choices
You get really especial Visio for 29$!

I find SQRTPI and IMSQRT in Excel's Worksheet functions. But can't find them for Visio
Oh for Pete's sake. The Alzheimer's is getting a lot worse. This happened in Excel, not Visio. My apologies.  :o :P :-\
Using Visio 365 on Windows 10