Excel IF function
This query is : Open
07 June 2021
How to insert the formula for a cell
The values as below
If the cell value is <700. The result is 3600
If the cell value is 700 to 900 the result is 4500
If the cell value is 901 to 2000 the result is 5800
What is the formula if the cell Q5
RESULT CELL IS Q6
The values as below
If the cell value is <700. The result is 3600
If the cell value is 700 to 900 the result is 4500
If the cell value is 901 to 2000 the result is 5800
What is the formula if the cell Q5
RESULT CELL IS Q6
07 June 2021
You will have to use two if functions in a single formula.
07 June 2021
Thank you very much sir
Please give the formula sir
Please give the formula sir
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- Off Market debit and credit transaction
- Itr 1 processing
- Showing Gift from relative in ITR for this year
- ITR returnFY25-26
- Share accounting-->fifo - capital gain - period as per fifo?
- INCOME TAX ON REDEVELOPEMENT OF FLAT
- ITR selection for salaries and capital gain less than L
- ITR 2 Short Term gain & Long term gain
- Short Term Capital gain on shares bought and sold after 2018 onwards
- Form 10E u/s 89(1). Need clarification because experts opinions differ !!!!
- Gst invoice numbering and delivery challan numbering
- Sales amount in Gstr1
- E Commerce GSTR1 & 3B how to file
- GST Cancellation without jurisdiction
- Legal Opinion on Registrar's Refusal to Investigate a Society for Non-Renewal and Non-Compliance
- GST Refund_RFD-01
- Form10BD was uploaded successfully without any Error but after 24 hours, Form10BE are not available
- Annexure B utility for GST Refund
- Tax amount diff in Gstr1 and 3B in tax compare reports
- Tds on GST in connection with sale to public company
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
