Thread: Conditionals
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Salvador EnrĂ­quez M
 
Posts: n/a
Default Conditionals

How do I write down a formula using conditionals to obtain 3 different values?
If Cell 1 and Cell 2 are higher than "Zero", I need to check if Cell 1 is
higher than Cell 2 then the answer is "A" but if Cell 2 is higher than Cell 1
the answer is "B", but if both are "Zero, the answer is "C"