RATE (If TOTAL PRICE AFTER TAX > 3500 then the rate is “HIGH”, otherwise it is
REASONABLE. how to right it in ms excel is there any sign for high and reasonable
Answers
Answer:
অ অ তাৰ পাছত কি কি যে এক গুৰুত্বপূৰ্ণ ভূমিকা পালন কৰে আৰু তাৰ বাবে আমি
Given : (If TOTAL PRICE AFTER TAX > 3500 then the rate is “HIGH”, otherwise it is REASONABLE
To Find : How to Write this in Excel
Solution:
Let say TOTAL PRICE AFTER TAX is in cell A22
A22 = TOTAL PRICE AFTER TAX
=IF(A22>3500,"HIGH","REASONABLE")
if Value in A22 > 3500 the Output would be HIGH
if Value in A22 ≤ 3500 the Output would be REASONABLE
=IF(TOTAL PRICE AFTER TAX>3500,"HIGH","REASONABLE")
Learn More:
Excel would evaluate the formula, = 20*10/5*8 and return this ...
https://brainly.in/question/14112243
a) (1)Give answer using Excel formula/function on the following ...
https://brainly.in/question/13949918
Given the above screenshot, which of the following formulas will ...
https://brainly.in/question/18087928