Ask Question
27 May, 03:19

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

+3
Answers (1)
  1. 27 May, 03:53
    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.
Know the Answer?
Not Sure About the Answer?
Find an answer to your question ✅ “What will be the result of this formula = if (a1 ...” in 📘 Mathematics if you're in doubt about the correctness of the answers or there's no answer, then try to use the smart search and find answers to the similar questions.
Search for Other Answers