Computer Science, asked by faizamohammad46, 4 months ago

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

Answered by Geetborpatragohain50
0

Answer:

অ অ তাৰ পাছত কি কি যে এক গুৰুত্বপূৰ্ণ ভূমিকা পালন কৰে আৰু তাৰ বাবে আমি

Answered by amitnrw
4

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

Similar questions