Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hello! So for column ETR, there needs to be an IF formula embedded into another IF formula. For instance, the calculation is the columns TXT/PI.

Hello! So for column ETR, there needs to be an IF formula embedded into another IF formula. For instance, the calculation is the columns TXT/PI. The ratio needs to be limited between 0 and 1. I need help with the IF formula, please.

image text in transcribed

txt xrd esub spi sic_2 pi 3212 15.363 mkvalt 37405.5843 330 -956 45 sale 42650 135.052 197.317 4.513 168.7421 0 35 -0.102 0 -0.141 -12.024 -100 35 0 7.716 10.514 0 0 6.455 179.905 163.357 276.855 184.96 121.704 6274.614 36 36 73 0 1545.254 1442.604 2222.588 2234.631 2725.239 39873.91 20247 444.388 27.1 36.32 103.812 64.294 43.471 299.694 ETR 10.27% 29.38% -1.58% 15.06% 22.23% 37.50% 34.76% 35.72% 4.78% 31.49% 31.36% 413.2812 2248.9093 2217.1528 2141.3616 2144.9358 2215.9582 103271.6885 67891.7357 243.2411 0 0 25.106 -33.317 -37.333 -3155.973 -346 -1.645 73 73 38 0 4610.182 1345 2531 797 38 51 24.74 7.759 1.598 txt xrd esub spi sic_2 pi 3212 15.363 mkvalt 37405.5843 330 -956 45 sale 42650 135.052 197.317 4.513 168.7421 0 35 -0.102 0 -0.141 -12.024 -100 35 0 7.716 10.514 0 0 6.455 179.905 163.357 276.855 184.96 121.704 6274.614 36 36 73 0 1545.254 1442.604 2222.588 2234.631 2725.239 39873.91 20247 444.388 27.1 36.32 103.812 64.294 43.471 299.694 ETR 10.27% 29.38% -1.58% 15.06% 22.23% 37.50% 34.76% 35.72% 4.78% 31.49% 31.36% 413.2812 2248.9093 2217.1528 2141.3616 2144.9358 2215.9582 103271.6885 67891.7357 243.2411 0 0 25.106 -33.317 -37.333 -3155.973 -346 -1.645 73 73 38 0 4610.182 1345 2531 797 38 51 24.74 7.759 1.598

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Markets and Institutions

Authors: Anthony Saunders, Marcia Cornett

6th edition

9780077641849, 77861663, 77641841, 978-0077861667

Students also viewed these Finance questions