vendredi 11 mai 2018

Insert another cell value into an IF function

I have an IF function and wish to include a variable string into the calculation.

Here is the standard function

=iferror(if(B2>=C2,"Your target has been reached",""))

I need to insert the value of E2 (which can either be >-,<=,=) between the B2/C2 values? So in theory it would be something like this

=iferror(if(B2,E2,C2),"Your target has been reached",""))

I have tried with CONCAT, INDIRECT with no success. Any ideas on inserting a cell value into a function?

Aucun commentaire:

Enregistrer un commentaire