View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Tom Hutchins Tom Hutchins is offline
external usenet poster
 
Posts: 1,069
Default Comparing results of two formulas

Try

=If(P1=AF3,"Approved","Denied")

Hope this helps,

Hutch

"KimW" wrote:

how do I compare the actual results of two formulas? Example: P1 has a
formula =edate(z1,10) and AF3 has a formula =edate(ac3,8). Want to compare
the results from P1 and AF3 and return "Approved" if they match or "Denied"
if they don't.