=if(B1=36,"Check No. " & A1,"")
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"Talladega" wrote:

Hi,

I have two colums, check number and number of months. I want to create a
formula showing if it is more than 36 months then it shows "Check No. 457" if
its under 36 months than blank.

Check No. Months Formula
74587 45 Check No. 74587
45647 12
44567 36 Check No. 44567
44767 6
57846 60 Check No. 57846