View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Comparing results of two formulas

hi,

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

Mike

"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.