ZuoTi.Pro
Question

Create a function in excel that converts two given numbers into whole numbers, taking into account...

Create a function in excel that converts two given numbers into whole numbers, taking into account the following considerations:

-One of the two numbers will always be equal to 1.

-The other number will always be smaller than one and bigger than zero.

Try it for the following: number1=1, number2=.77

math   Statistics-And-Probability   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Cllpboard B3 屁 =IFERROR(IF(SBS1>$BS2,(MAX(SBS1SB$2)-$BS2)/(ABS(SBS1SB$2)),0.77+(MAX(SBS1:SBS2)-$BS2)/(ABS(SBS1SB$2))),1) 1x 1

I have created the function's formula in the cells above in excel. You can input any random numbers in yello cells and get the required answer.

Hope the above ans has helped you in understanding the problem. Please upvote if it has already helped. Good Luck!!

0 0
Add a comment
Know the answer?
Add Answer to:
Create a function in excel that converts two given numbers into whole numbers, taking into account...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • 2. This function compares two numbers and returns them in increasing order. 1. Fill in the...

    2. This function compares two numbers and returns them in increasing order. 1. Fill in the blanks, so the print statement displays the result of the function call in order. 1 # This function compares two numbers and returns them 2 # in increasing order. 3 - def order_numbers(number1, number2): 4. if number2 > number1: return numberi, number2 6 else: return number2, number1 9 Run # 1) Fill in the blanks so the print statement displays the result # of...

  • there is a function to create two random numbers between 1 and 25 and a function...

    there is a function to create two random numbers between 1 and 25 and a function to add them together. add the prototypes correctly, call them from main correctly and output the results. The three functions should be subtractNumbers, multiplyNumbers, and divideNumbers. Remember that division won't always yield an integer so be sure to take care of that issue within the function (don't change the variable declarations). Don't change the code that I've given you. Follow the same pattern. #include...

  • Question 1: Write down an function named bitwisedFloatCompare(float number1, float number2) that tests whether a floating...

    Question 1: Write down an function named bitwisedFloatCompare(float number1, float number2) that tests whether a floating point number number1 is less than, equal to or greater than another floating point number number2, by simply comparing their floating point representations bitwise from left to right, stopping as soon as the first differing bit is encountered. The fact that this can be done easily is the main motivation for biased exponent notation. The function should return 1 if number1 > number2, return...

  • using C , comments will be appreciated. Question1 Write down an function named bitwisedFloatCompare(float number1, float...

    using C , comments will be appreciated. Question1 Write down an function named bitwisedFloatCompare(float number1, float number2)that tests whether a floating point number number1is less than, equal to or greater than another floating point number number2, by simply comparing their floating point representations bitwise from left to right, stopping as soon as the first differingbit is encountered. The fact that this can be done easily is the main motivation for biased exponent notation. The function should return 1 if number1...

  • 12. If two groups of numbers have the same mean, then their standard deviations must also...

    12. If two groups of numbers have the same mean, then their standard deviations must also be equal. their medians must also be equal. their modes must also be equal. other measures of location need not be the same 13. The Sample Mean can never be negative. can assume any value between the highest and the lowest value in the sample. can never be zero. is always smaller than the mean of the population from which the sample was taken

  • Write and test a function toDecimal() that converts a roman number such as MCMLXXVII to its...

    Write and test a function toDecimal() that converts a roman number such as MCMLXXVII to its decimal number representation. Write a main program to test the function. Your function should have two arguments - the roman number as a string, and an error processing function. Write a helper function that will return the numeric value of each of the letters used in roman numbers. Then convert the string argument as follows look at the first two characters. If the first...

  • Most computer languages include a function that can be used to generate random numbers. In Excel,...

    Most computer languages include a function that can be used to generate random numbers. In Excel, the RAND function can be used to generate random numbers between 0 and 1. If we let x denote a random number generated using RAND, then x is a continuous random variable with the following probability density function. for 0 sxs 1 elsewhere (a) Graph the probability density function. f(x) f(x) EEEEEEEEEEEEE Endas tiers - 3 - Terce BOORTE E segments Egertice Tesegent o...

  • *In JAVA please* Tasks This lab has two parts: Write a recursive method that converts a...

    *In JAVA please* Tasks This lab has two parts: Write a recursive method that converts a decimal number to a different base number system. Print out the results after testing your method on a few different inputs. Task 1 – Recursive Method Create a recursive method that returns a given number converted from base ten to a given other base number system ranging from two to thirty-six. A decimal number, or base ten number, can be expressed in any other...

  • Write a program in C or a script in bash, called “compare” that takes two numbers on the command line and compares them....

    Write a program in C or a script in bash, called “compare” that takes two numbers on the command line and compares them. The program should print the result of the comparison. Specifically, it should print “<x> is <comparison> <y>”, where <x> is the first number, <y> is the second number and <comparison> is one of “equal to”, “greater than” or “less than”. If the two numbers are equal, the program should have an exit status of zero. The exit...

  • 3. Create a MATLAB script or function that takes converts a 10-element array, B, of zeros...

    3. Create a MATLAB script or function that takes converts a 10-element array, B, of zeros and ones and converts it into a floating point number, F, using the following rules: 1. The leading bit indicates a positive (0) or negative (1) number ii. Bits 2 through 4 are the binary representation of e, the exponent Ill Bits 5 through 10 represent the number precision as: (sign).(1 + bit5.2-1 + bith. 2-2 + ... + bit10.2-6). 2-3 iv. Finally, if...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT