excelenergy
Board Regular
- Joined
- Jun 7, 2012
- Messages
- 142
Hello,
My question may be relatively simple. Im curious about adding a function into the formula which I currently have that works. The formula is an IFISERROR.
=IF(ISERROR(MATCH(O14,A$1:E$5,0))=FALSE,"Yes","No")
The way it works is - O14 checks for a value in my Array of A1:E5. If it finds that matching value it returns a yes or no. Pretty simple right..
What I would like to do, is if the formula finds the matching value, I want to add in a way to divide O14/the Z41.
Does anyone have any recommendations on the best way to do that?
My question may be relatively simple. Im curious about adding a function into the formula which I currently have that works. The formula is an IFISERROR.
=IF(ISERROR(MATCH(O14,A$1:E$5,0))=FALSE,"Yes","No")
The way it works is - O14 checks for a value in my Array of A1:E5. If it finds that matching value it returns a yes or no. Pretty simple right..
What I would like to do, is if the formula finds the matching value, I want to add in a way to divide O14/the Z41.
Does anyone have any recommendations on the best way to do that?