I have a spreadsheet, in columns A & B are some numbers. I'm subtracting B from A - =sum(b1-a1) in column C. Can a formula be written, if the sum is equal or greater than 8, it will display 1? If the sum is 7 or less, it will display the sum. Or, does this need to be in a different column?
Thanx...LT
Last edited by Ltat42a; 05-13-2009 at 12:29 PM. Reason: SOLVED
Hi,
You don't need the SUM function:
=IF(B1-A1>=8,1,B1-A1)
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
Ah.....that works!Originally Posted by sweep
Thanx sweep.....LT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks