View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Don[_6_] Don[_6_] is offline
external usenet poster
 
Posts: 6
Default How do I create a cell formula to achieve this?

How do I create the following to determine the value of Cell C?

IF Cell A = blank then Cell C = "ZZZ"
IF Cell A = non-blank and Cell B = non-blank, then Cell C = Cell B
IF Cell A = non-blank and Cell B = blank, then Cell C = "ZZZ"

Thanks,
Don