Main Menu

SQRT vs sqrt?

Started by Jennifer, July 28, 2020, 02:55:03 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Jennifer

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 2019, part of Office 365 on Windows 10

Surrogate

#1
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!

Surrogate

Quote from: Jennifer on July 28, 2020, 02:55:03 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

Jennifer

Quote from: Surrogate on July 28, 2020, 04:15:52 AM
Quote from: Jennifer on July 28, 2020, 02:55:03 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 2019, part of Office 365 on Windows 10