Ask Question
24 March, 11: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?

+1
Answers (1)
  1. 24 March, 13:47
    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?
Get an answer to your question ✅ “What will be the result of this formula = if (a1 ...” in 📙 Mathematics if there is no answer or all answers are wrong, use a search bar and try to find the answer among similar questions.
Search for Other Answers