Thread: directing cell contents dependent on its value
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ozgrid.com ozgrid.com is offline
external usenet poster
  
Posts: 464
Default directing cell contents dependent on its value
=IF(AND(ISNUMBER(A1),A136),A2,IF(AND(ISNUMBER(A1) ,A1<36),A3,0))



--
Regards
Dave Hawley
www.ozgrid.com
"Debi" wrote in message
...
How do i write a formula that will redirect a cell contents to one of two
cells.
One for if its less than 36 and one if its over 36. I am using it as an
electronic clockcard monitoring system and need to transfer a debit or a
credit balance to the sheet for the next week.

Reply With QuoteReply With Quote