help with "if" function

[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

 

[Frank Kabel]

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

 

[Alan]

=IF(AND(A1>A2,A1<A3),"Renewal Required","See Other Column")
Regards,