View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ksean ksean is offline
external usenet poster
 
Posts: 55
Default If - Then question

How would I write a formula to handle this problem?
If the value in cell D20 is €˜U18 then the result in cell D6 is a €˜0
however if the value in D20 is anything else then the result in cell D6 is
the value in N5