Advertisement

Strength
Machines
Geometry
Heat
Maths
Fluids
Add-Ins
Misc. Topics
Dynamics
Fun
Electricity
Links
Finance

Member Login

Enter Amount:


Search Amazon:


Search other Amazon regions.

Who's Online

We have 16 guests and 30 members online
Home arrow Forum

ExcelCalcs
Welcome, Guest
Please Login or Register.    Lost Password?
ExcelCalcs XLC XLC Issues
Re:show equation w/ "n/a" in function (1 viewing) (1) Guest
Use this forum to discuss any problems, user suggestions or any other issue regarding the XLC software.
Go to bottom Post Reply Favoured: 0
TOPIC: Re:show equation w/ "n/a" in function
#952
kau ()
User Offline Click here to see the profile of this user
show equation w/ "n/a" in function 9 Months, 3 Weeks ago Karma: 0  
Hello, great addin...
If the equation has "n/a" in it, the equation won't show when the button is pressed on the toolbar.

Code:
=IF(C68<1,"ok","na")
prints the equation.
Code:
=IF(C68<1,"ok","n/a")
does not print the equation. It's not that big of a deal to work around it if its too difficult to fix. Thanks, Ben
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#954
JohnDoyle ()
Please support us with an XLC Pro Subscription.
User Online Now Click here to see the profile of this user
Gender: Male MoreVision Location: LEEDS, WEST YORKSHIRE, UK Birthdate: 1965-02-24
Re:show equation w/ "n/a" in function 9 Months, 3 Weeks ago Karma: 470  
It is playing up because XLC recognises "/" as an operator. I suggest you use a work around for the time being and I'll put it on my 'todo' list for sometime in the future. Thanks for reporting it in.
 
Report to moderator   Logged Logged  
 
Training, engineering consultancy and finite element analysis.
  The administrator has disabled public write access.
Go to top Post Reply
Sponsored by MoreVision Engineering Consultantsget the latest posts directly to your desktop
 
  © 2008 MoreVision Ltd.