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