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


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

Flora EdwardsMedicineCommented:
what is Co in your formula?  is it Cprob      0.83 ?
ShumsExcel & VBA ExpertCommented:
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.
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.
Your Guide to Achieving IT Business Success

The IT Service Excellence Tool Kit has best practices to keep your clients happy and business booming. Inside, you’ll find everything you need to increase client satisfaction and retention, become more competitive, and increase your overall success.

ShumsExcel & VBA ExpertCommented:
Try attached...

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.
ShumsExcel & VBA ExpertCommented:
You're Welcome Paul. Glad I was able to help you now.
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.
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.