ExcelBanter - Comparing results of two formulas

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Comparing results of two formulas (https://www.excelbanter.com/excel-discussion-misc-queries/246986-comparing-results-two-formulas.html)

KimW

Comparing results of two formulas

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.

Tom Hutchins

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.

Mike H

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.

All times are GMT +1. The time now is 11:12 PM.