Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear team
I have two questions.
1) How can I link two separate text box with formula? Example : - Textbox A has a value of 3000 and Textbox B has a value of 7000. I need a formula in Textbox C to get the difference between two textboxes (7000-3000.)
2) In Textbox D i need the % of the variance
Please help
what is that two expressions in two text box?
=Exp1-Exp2
You can wright
in Text Box C = (Text box A expression ) - (Text box B expression )
in Text Box D =( (Text box A expression ) / (Text box B expression ))-1
Hope this will help you !!
Presently I did in this way only. I thought there will be an easy way like we do in table like Coloumn 1 -Coloumn 2
Yes, I did in this way. But I don't know the format to get the sign %
create two variables for that expressions and use like below
=(vTextbox1) - (vTextbox2)
use
num (Value,'#,##0.0%')