Easy Office

Excel IF function

This query is : Open 
Profile Image

Profile Image

(Querist)
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
Profile Image

CA Altamush Zafar

Profile Image

CA Altamush Zafar (Expert)
07 June 2021 You will have to use two if functions in a single formula.
Profile Image

A Srinivas

Profile Image

A Srinivas (Querist)
07 June 2021 Thank you very much 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

CAclubindia's WhatsApp Groups Link


Similar Resolved Queries


loading


Unanswered Queries


Easy Office

Trending Online Classes

view all classess
CCI Pro


Answer Query



Quick Links