IF function problem
Hi to all,
I would really appreciate any help i can get to solve my prob. I am trying to develop a formula using the IF function that will give me a number result rather than a word i.e. True / false etc.
Here is the first part of my formula =IF(A1>10 what i want to say here is , then show the number that is in cell A1, the other half of the formula is if the number in A1 is less than 10, then show 0
Last edited by bannister47; 06-01-2011 at 11:18 AM.
What if A1=10?
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
two possible solutions, but that depends on the what if A1 = 10, if you need to include this as a paramater you will need to use an IF(OR( function, other wise you can use a simle If then statment.
Simple IF statment:
IF(A1>10,A1,0)
which means, If A1 is greater then 10, show me A1, if its not just give me a 0.
IF(OR Statment:
* Use this if you need to include 10 as a value
IF(OR(A1>10,A1=10),A1,0)
which means if a1 is greater or equle to 10 then show me A1, if these conditions are false then give me a 0.
IF OR worked a treat, many thanks, has been driving me crazy.
FYI...
that is better written as:
=IF(A1>=10,A1,0)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks