Excel if formulla

 

=IF(logical_test,value_if_true,value_if_false)                                                                                                                                                       

=if(Put the condition,value if condition is satisfied,Value if Condition is not satisfied)

The "IF" formulla is one of best advance formulla available in excel. The formulla behaves on the logic of If and Than.

Using this formulla user can set a predefined rule that if a value is equal to x than what should be the result and if its not x than what should be the result.

 

Using above formulla you can always get your basic data work done. We will take a bigger and practical useful example of how to handle various figure using if function.

Student

Marks(B8)

Result

Amar

45

=IF(B8>35,"PASS","FAIL")

Akbar

40

PASS

Anthony

46

PASS

Ram

80

PASS

Shyam

33

FAIL

Geeta

43

PASS

Sheeta

21

FAIL

 

Above formulla is a simple case of how  by using formulla a lot of time can be saved. One has to just put the formulla and than copy and paste in all other cells.

 

Read full here

Replies (2)
hey This is very nice It help me to learn tis function very easily. thanxxx

nice & simply explained.. too good.!

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
Featured ARTICLESHIP 31 October 2026
CA Articleship

apricus india

Navi Mumbai

CA Inter

View Details
Company
19 November 2026
Accounts & Taxation Executive

MCSR and Associates LLP

Hyderabad

CA Inter

View Details
Company
Featured 29 October 2026
Accounts Executive

Synergy Keystone

Chennai

B.Com

View Details
Company
ARTICLESHIP 18 November 2026
Articled Assistant

A.Singhi & Co

Kolkata

CA Inter

View Details
Company
20 November 2026
Article

S & N CO

Mumbai

CA Inter

View Details
Company
02 November 2026
Audit Executive

SRJP & Co LLP

Kochi

CA Inter

View Details
Company
21 November 2026
Asst. Manager / Deputy Manager

Aco Perfumes & Cosmetic Pvt Ltd

Mumbai

CA

View Details
Company
Featured 07 November 2026
Paid Assisstant

DPV & Associates

Chennai

CA Inter

View Details