0
Insert an IF statement in cell C4 that inserts 7 percent if B4 is greater than 99999 and inserts 5 percent if B4 is less than 100000?
Wiki User
∙ 13y ago
Using Excel, the statement in cell C4 would be input as follows:
=if(B4>99999,0.07,0.05)
However, the case where B4 is in between 99999 and 100000 is not accounted for in the solution (or in the question).
Wiki User
∙ 13y ago
Add your answer:
Earn +20 pts
What is 20 percent of 100000?
20% of 100000= 20% * 100000= 0.2 * 100000= 20,000
What is 100000 plus 20 percent?
100000 + 20% = 100000 + (20/100)(100000) = 100000 + (.2)(100000) = 100000 + 20000 = 120,000
What is 6.5 percent of 100000?
6.5% of 100000 = 100000*6.5/100 = 6500
What is 7 percent of 100000?
It is 100000*7/100 = 7000.
How much is 2.5 percent of 100000?
2.5% of 100,000= 2.5% * 100000= 0.025 * 100000= 2,500
What is 100000 percent of 6?
6000 is 100000 percent of 6.
What percent of 100000 is 100000?
It is: 100%
What is the percent of 100000?
100000 in % is 10000000%
How do you write 1000 as a percent?
1000 as a percent = 100000%= 1000 * 100%= 100000%
What is 100000 x 93 percent percent equal?
93% of 100000 = 93000
What is 20 percent of 100000?
20% of 100000= 20% * 100000= 0.2 * 100000= 20,000
What is 100000 plus 20 percent?
100000 + 20% = 100000 + (20/100)(100000) = 100000 + (.2)(100000) = 100000 + 20000 = 120,000
What is 60 percent of 100000?
60% of 100000 = 60,000
What is 3.5 percent of 100000?
35% of 100,000= 35% * 100000= 0.35 * 100000= 35,000
What is 19.77 percent of 100000?
19.77 percent of 100000 = 18.386119.77% of 93= 0.1977 * 93= 18.3861
What you is 3 percent of 100000?
3% of 100000 = 3000 3% of 100000 = 3% * 100000 = 3%/100% * 100000 = 0.03 * 100000 = 3000
What is 6.5 percent of 100000?
6.5% of 100000 = 100000*6.5/100 = 6500
