Advertisement
ExcelCalcs
Welcome, Guest
Please Login or Register.    Lost Password?
ExcelCalcs XLC XLC Issues
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: show equation w/ "n/a" in function
#952
kau (User)
Fresh Boarder
Posts: 1
graphgraph
User Offline Click here to see the profile of this user
show equation w/ "n/a" in function 4 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 (Admin)
Admin
Posts: 400
graph
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 4 Months, 3 Weeks ago Karma: 469  
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  
 
Talk to me about training.
Talk to me about engineering consultancy work 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