Tweak required to equation

vipaman
vipaman used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Flora EdwardsMedicine

Commented:
what is Co in your formula?  is it Cprob      0.83 ?
ShumsManaging Director/Excel VBA Developer
Distinguished Expert 2018

Commented:
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

Author

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
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Managing Director/Excel VBA Developer
Distinguished Expert 2018
Commented:
Try attached...
Copy-of-scaffoldv4.xlsx

Author

Commented:
Excellent Shums. Apologies yesterday, I thought I was spreading the points! :-) I have been offline for a while.
ShumsManaging Director/Excel VBA Developer
Distinguished Expert 2018

Commented:
You're Welcome Paul. Glad I was able to help you now.

Author

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.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial