Excel IF function

This query is : Open 
Quick Summary
This discussion explains how to insert the Excel IF function into a cell. The IF function allows you to perform a logical test and return one value if the test is true, and another if it's false. It's a fundamental tool for making your spreadsheets more dynamic and responsive to data.

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



Similar Resolved Queries


loading


Unanswered Queries


Trending Online Classes

view all classess

CCI Pro
Meet our CAclubindia PRO Members
Pro Member B L BhojwaniB L BhojwaniPro Member Anju SusanAnju SusanPro Member Shameem ahmedShameem ahmedPro Member Gurunathan kannanGurunathan kannanPro Member sachinguravsachingurav
Subscribe to Pro
Join an elite circle of professionals



Answer Query



Quick Links



Browse by Category