• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 296
  • Last Modified:

Need to know how to use IF then statements

How do i enter the following as an IF function:  If data is equal to data; compute f73-f90 if not 0; compute f90-f73
  • 2
1 Solution
If you'd like a little explanation, true is anything that is not 0.  The parts of an IF statement are as follows IF(condition, True, False)  By checking the conditioon F90-F73, the value of F90-F73 (the section labeled true, is returned provided the condition which is also F90-F73 returns anything that is NOT 0.  If 0 is returned then the False part of the evaluation is returned, which in this case we elected not to define, hence 0 translatest to nothing, anything NOT 0 translatest to whatever F90-F73 equals.
Saurabh Singh TeotiaCommented:
Lets says -- U have 1st data in A coloumn and second data in b coloumn...and in row number 1..

If a1 is not equal to b1..its gonna give a blank value...

This will do the trick for u...
I'm at a temp office right now and do not have Excel install on this computer.  When I get home I will work on it and post you the Syntax here.  I just need to know what information do you want displayed in this cell after all the IF Statements have ran?

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now