help with "if" function

  • Thread starter Thread starter Andy Knowles
  • Start date Start date
A

Andy Knowles

Hope you can help
if a1>a2 but <a3 how do I return the value "Renewal
required" and if a1>a3 "see other column"

Thanks in anticipation


Andy
 
Hi
if I understood your conditions correctly try
=IF(A1>A2,IF(A1<A3,"Renewal required","See other
column"),"A1<=A2")
 
Back
Top