Ask question

Ask question

All categories

4 years ago

6

What will be the result of this formula =if(a1<100000,a15%,a17.5%) , if the cell a1 has a value of 90000?

1 answer:

jasenka [17]4 years ago

4 0

<span>For this IF function, look at cell A1. The logical test asks if the value in A1 is less than 100,000: in this case, the value of 90,000 would be less. If the value in A1 is under 100,000, the value is to be multiplied by 0.05 (5%), and multiplied by 0.075 if it is 100,000 or greater (7.5%). For a value of 90,000 * 0.05, the value that would be displayed in the cell with the IF function would be 4,500.</span>

You might be interested in

the pitch of a roof is the number of feet the roof rises for each 12 feet horizontally if a roof has a pitch of 8,what is the sl

Korolek [52]

So slope=rise/run
rise=8
run=12
8/12=4/6=2/3
the slope=2/3

8 0

3 years ago

Josie and Allanah are each saving money. Josie starts with 100$ per week in her savings account and adds 5$ per week. Allanah st

Natasha2012 [34]

Answer:

Josie: 100 + 5x

Allanah: 10 + 20x

x is to represent the unknown variable of how many times they will repeat this process.

4 0

3 years ago

Read 2 more answers

There are 600 performers in a dance recital. The ratio of men to women is 4:6. How many men performers were in the dance recital

posledela

Answer: 240 men

Step-by-step explanation:

From the question, we are informed that there were 600 performers in a dance recital and that the ratio of men to women is 4:6.

Fraction of men at the recital = 4/10

Fraction of women at the recital = 6/10

The number of men performers that were in the dance recital will be:

= 4/10 × 600

= 240 men

There were 240 men at the recital.

5 0

3 years ago

Weights of different sandwiches in two lengths are shown in the table.

Alexandra [31]

Answer:

Egg salad sandwich is proportional to its length

Step-by-step explanation:

Weight of Sandwiches by Length of Roll

6-inch Roll 12-Inch Roll

Cheese sandwich $\frac{1}{4}$ $\frac{3}{4}$

Chicken salad sandwich $\frac{3}{4}$ $1\frac{3}{4}$

Egg salad sandwich $\frac{2}{3}$ $1\frac{1}{3}$

For cheese sandwich proportion

$\frac{6}{\frac{1}{4}}=\frac{12}{\frac{3}{4}}\\24 \neq 16$

So, Cheese sandwich weight is not proportional to its length

For Chicken salad sandwich proportion

$\frac{6}{\frac{3}{4}}=\frac{12}{\frac{7}{4}}\\8 \neq \frac{48}{7}$

So, chicken salad sandwich is not proportional to its length

For Egg salad sandwich proportion

$\frac{6}{\frac{2}{3}}=\frac{12}{\frac{4}{3}}\\9=9$

So, egg salad sandwich is proportional to its length

6 0

3 years ago

Insert <, >, or = between the fractions to make the sentence true. <br><br> 3/4 _____ 4/7

ratelena [41]

3/4 = .75
4/7 = .57

the answer is : 3/4 > 4/7

6 0

3 years ago

Read 2 more answers