Andreamary
asked on
Adding another criteria to an Excel formula
My current formula below resides in column AE:
=IFERROR(IF($AC2="","",IF( $AC2<$AD2, "Yes","No" )),"")
I would like to incorporate the following additional criteria in the above formula:
IF $AD2="n/a", then $AE2 should be ""
Thanks!
Andrea
=IFERROR(IF($AC2="","",IF(
I would like to incorporate the following additional criteria in the above formula:
IF $AD2="n/a", then $AE2 should be ""
Thanks!
Andrea
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Pleased to help Andrea! :)
ASKER