Thread: Cell Range
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Altec101[_22_] Altec101[_22_] is offline
external usenet poster
  
Posts: 1
Default Cell Range

The data in A1 would look like this: 0:03:00


The formula is working great, it does what it needs to do.
This is the formula:

=IF(E2=Buckets!$C$1,"A",IF(E2=Buckets!$C$2,"B",I F(E2=Buckets!$C$3,"C",IF(E2=Buckets!$C$4,"D",IF( E2=Buckets!$C$5,"E","NA")))))


--
Altec101
------------------------------------------------------------------------
Altec101's Profile: http://www.excelforum.com/member.php...o&userid=34539
View this thread: http://www.excelforum.com/showthread...hreadid=571898

Reply With QuoteReply With Quote