Linking the sign value in another cell to a formula in another

[Mark McInerney]

I am trying to create the following:

=IF(C4&INDIRECT(D4)&E4,"Y","N")

in short this would be =If(c4>e4,"Y","N") - the value in cell d4 is ">"

where D4 can be changed to ">" "<" or "="

Is this possible? Thanks - Mark.

 

[JGordon11]

with an evaluate function in a named formula you can. To do so:

1) Select cell F4.
2) Go to Formulas,
3) Define Name,
4) name it whatever you like (I used myFormula),
5) in the "Refers to" section enter =EVALUATE(c4 & d4 & e4)
6) click OK.

Then when you type =myFormula (or whatever you named it) in a cell it will evaluate the expression created by concatenating the three cells to the left of it, as in the examples below. I'll leave it to you to make the adjustments if you want "Y" and "N" instead of TRUE and FALSE.

Drawback to this approach is that the sheet would need to be saved as xlsm. If the xlsm is a problem then nested IFs and ANDs could be used as depicted in column G

Book1
	C	D	E	F	G
4	5	=	5	TRUE	TRUE
5	10	<	5	FALSE	FALSE
6	10	>	5	TRUE	TRUE
7	10	*	5	50
8	10	-	5	5
9	2	^	5	32
10	10	/	5	2
11	5	=	5	TRUE
Sheet2

Cell Formulas
Range	Formula
G4:G6	G4	=IF(AND(D4=">",C4>E4),TRUE,IF(AND(D4="<",C4<E4),TRUE, IF(AND(D4="=", C4=E4),TRUE,FALSE)))
F4:F11	F4	=myFormula

 

[Mark McInerney]

Hi JGordon11 - I'll give it a go - Many Thanks for taking the time to review my query - really appreciate it - Happy Xmas to you and family! Thank You.