Look at this for example
Using Excel 2007 32 bit
Worksheet: Sheet1
Row\Col F 95 =IF(G94>=$B$3,"",G94+1)
IF the value of cell G94 is greater than or equal to the calue in B3 ( the limit ) then the formula returns a value in the cell of ""
"" is just Excel's way of saying nothing.
Otherwise if that condition is not met the value returned to the cell is given by
( the value in cell G94 ) +1





Reply With Quote
Bookmarks