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?
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
