Good afternoon
Pretty simple question here but my brain is just dead, I have a time line that breaks hours up over a certain amount of months, and I was ondering if it was possible to set up a condition that once my numbers equal my total sum can I get it to say complete in the next cell.
ie say this is my time line
sum= 100------10-10-10-10-10-10-10-10-10-10 can I get the following cell to say complete ?
Probably. Let's say you have the value you want to sum to in cell A1 and your values in C1:N1
In B1 = IF(SUM(C1:N1)>=A1,"Complete","")
Is that what you are looking for?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
I believ I can make that work,
thanks ChemistB
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks