Tweak required to equation

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
vipamanAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

FloraCommented:
what is Co in your formula?  is it Cprob      0.83 ?
0
ShumsDistinguished Expert - 2017Commented:
Hi Paul,

I see, you accepted Norie's solution in your previous post and using my formula :)

What are the cell references for Co(z), Ce(z) - I believe its D45, Qb - I believe its D35, CetQb?

I have added above formula with Quotation Marks, while applying the cell reference remove double quote and refer to cells, if you face any difficulty, please post the workbook with complete cell references, I will edit the formula.
scaffoldv4.xlsx
0
vipamanAuthor Commented:
Hi, I have added lines 50-57 to explain what cell D41 should produce depending on variable inputted. I am wondering whether this would suit Index and Match instead. This problem has evolved unfortunately with understanding the Eurocodes in more detail.
Copy-of-scaffoldv4.xlsx
0
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

ShumsDistinguished Expert - 2017Commented:
Try attached...
Copy-of-scaffoldv4.xlsx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
vipamanAuthor Commented:
Excellent Shums. Apologies yesterday, I thought I was spreading the points! :-) I have been offline for a while.
0
ShumsDistinguished Expert - 2017Commented:
You're Welcome Paul. Glad I was able to help you now.
0
vipamanAuthor Commented:
Once last query ref cells, is there a way to format the text to keep subscript. I substituted out one of the equations to point to a properly formatted equation and it does not keep the formatting once displayed in D41? The use of subscript is quite important.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.