route217
asked on
update current if formula
Hi Experts excel 2007
I need to amend current if formula to accommodate one additional step
IF(AND(A2="Closed",B2="crc "),"time out","")
so if e2 has a value (always text), then e2 into cell f2 otherwise the above formula. .
I need to amend current if formula to accommodate one additional step
IF(AND(A2="Closed",B2="crc
so if e2 has a value (always text), then e2 into cell f2 otherwise the above formula. .
If E2 is always text then how can you multiply it with F2?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hold on
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Work's