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?
 
ShumsConnect With a Mentor Distinguished Expert - 2017Commented:
Try attached...
Copy-of-scaffoldv4.xlsx
0
 
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
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.