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 11 guests and 31 members online
Home arrow Forum

ExcelCalcs
Welcome, Guest
Please Login or Register.    Lost Password?
Solved (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: Solved
#1131
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
Solved 5 Months, 1 Week ago Karma: 470  
moises I think that their is a " " character in the formula which is causing the problem. Your cell formula reads:
=IF(D10<D12,9.5*6.895, IF(AND(D12<D10, D10<D14), (10.5-0.07*SQRT(D10))*6.895, IF(D10>D14, (23600/D10)*6.895, ERROR)))
If you change this to:
=IF(D10<D12,9.5*6.895, IF(AND(D12<D10,D10<D14), (10.5-0.07*SQRT(D10))*6.895, IF(D10>D14, (23600/D10)*6.895, ERROR)))
Notice the " " character remove in front of "D10<D14"
Now your equation will be rendered correctly.

I'll be able to fix this bug in a future release but if you could use this work around for now.

Thanks for reporting this in. I really rely on user feedback to notice these bugs so that I can improve the product in the future.
 
Report to moderator   Logged Logged  
 
  The administrator has disabled public write access.
      Topics Author Date
    thread link
Error in nested IF w/ AND function
megamaxx 2008/06/24 13:22
    thread link
thread linkthread link testing attachments
JohnDoyle 2008/06/24 18:13
    thread link
thread linkthread linkthread link Re:testing attachments
JohnDoyle 2008/06/24 18:16
    thread link
thread linkthread linkthread linkthread link Re:testing attachments
megamaxx 2008/06/25 05:16
    thread link
thread linkthread link Solved
JohnDoyle 2008/06/26 12:08
    thread link
thread linkthread linkthread link Re:Solved
megamaxx 2008/06/27 13:58
Go to top Post Reply