troubleshooting Question

Tweak required to equation

Avatar of vipaman
vipamanFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft OfficeMicrosoft ExcelMicrosoft ApplicationsSpreadsheets
7 Comments1 Solution208 ViewsLast Modified:
This follows on from a previous question and some validation checking.

=IF(AND(D37="Yes",D39="Town"),"(Co(z) + 0.6)/1.6)^2",IF(AND(D37="No",OR(D39="Sea",D39="Country")),"Ce(z) x qb","Ce(z) x Ce,t x qb"))

Simplified version

=IF(AND(D37="Yes",D39="Town"),"Equ3",IF(AND(D37="No",OR(D39="Sea",D39="Country")),"Equ1","Equ2"))

Based on the Eurocodes for wind design on which I am basing this spreadsheet I have an issue.  

The final answer for Equ 3 should equal Equ1 + equation 3 ( which is static = Co(z) + 0.6)/1.6)^2) or Equ 2 +  equation 3.

Not sure of how to build this one. I had thought using the cell E41 adjacent to D41 to display?
scaffoldv3.xlsx
ASKER CERTIFIED SOLUTION
Shums
Excel VBA Developer
Join our community to see this answer!
Unlock 1 Answer and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros