Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Excel Training and help » IF function
|
|
|
Bookmark this page|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
IF function
Resolved · High Priority · Version 2007
Reply
IF function
If I want to use the IF function to see whether a range of cells are greater than 1 (if they are then I need to invoice an extra place), if the value is true I need to know how many cells are greater than 1, and if the value is false the answer is 0. What do I put in the formula for the true function as I need to know how many cells were greater than 1?For upcoming training course dates see: Pricing & availability
RE: IF function
Hi LouiseThank you for your question. Depending on how your data is organised there are a couple of ways you may want to approach this. The IF function uses the syntax
=IF(Logical test,Value if True,Value if false)
So if your records are in a column e.g. A1 to A10 you might put an IF statement in B1 to B10 checking each cell in column A.
In B1 you could put =IF(A1>1,1,0). Wherever a cell from A1 to A10 has a number greater than 1 its neighbour cell in column B will also contain a 1. You could then total the B column to find how many times this happens. Only where a cell in column A is greater that 0 would a cell in column B contain a value.
Does this help or is your data organised differently? Let me know how you get on I will try to help further.
Kind regards,
Andrew
Kind regards,
Andrew
Wed 9 Dec 2009: Automatically marked as resolved.
|
 |
|
» Forum post: Conditional Formatting |
I am looking to format a cell colour (B2) if a different cell (A2)contains the word "International". The entry in A2 is based on several possible entries, of which there are 3 varieties that contain the word "International": "Juni..
