98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » IF function
IF function
Resolved · High Priority · Version 2007
Thu 3 Dec 2009, 11:45Delegate Louise said...
Louise has attended:
Excel Intermediate course
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?
Thu 3 Dec 2009, 14:35Trainer Andrew said...
RE: IF function
Hi Louise
Thank 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.
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. |
Excel tip:Use the Ctrl-key for quick navigation in Excel 2010If you want to move quickly to the right, left, top or bottom of your spreadsheet, just press Ctrl and one of the arrow keys. If you want to then select all the data in that particular row or column, hold down the Shift key and press Ctrl and an arrow key. |
