View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ScoobyDoo ScoobyDoo is offline
external usenet poster
 
Posts: 4
Default Nested If/and statement

Hi, I would like to be able to return some text based on the numbers compared
in 2 cells v another 2 cells i.e.

if N16 N15 and M16 < M15, "No change", if N16 = N15 and M16 < M15 "No
Change", if N16 = N15 and M16 = M15 "Increase", if N16 = N15 and M16 M15
"Calsurp", if N16 < N15 and M16 < M15 "Inccal", if N16 < N15 and M16 =M15
"Skip", if N16 n15 and m16 = m15 "incrcal", if n16 n15 and m16 m15
"Incrcal calsurp"

Any help with the above would be grately appreciated, thanks in advance