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:

4 0

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.

You might be interested in

Which expression is equivalent to 2^5?

tatiyna

5 x 5

Hope This Helps!
Can I get Brainliest?

8 0

3 years ago

What sums are equal to 6/12?

nadya68 [22]

Hey there!

"What sums are equal to $\bold{\frac{6}{12}}$ ?"

$\bold{\frac{6}{12}=\frac{1}{2}=0.5 }$

It can't be $\bold{A. \frac{6}{12} + \frac{6}{12}+ \frac{6}{12}+\frac{6}{12}+\frac{6}{12}+\frac{6}{12}}$ because the answer would be $\bold{3}$
It can be $\bold{B.\frac{2}{12} + \frac{1}{12} + \frac{1}{12} +\frac{2}{12}}$
It can also be $\bold{C. \frac{5}{12} + \frac{1}{12}}$
It can also again be $\bold{\frac{1}{12}+\frac{1}{12}+\frac{1}{12}+\frac{3}{12}}$
$\boxed{\boxed{\bold{Answers: B,C,D}}}}$