if statement for tow almost same value

ghassanaldalati — Wed, 25 Nov 2020 16:16:04 GMT

in TextBox I Have tow percentage Value ( A% & B% )

the different between the tow percentage value is very small ( less or more than 0.00001 )

now i want to create a logic if statement that show :

if ( {the different between the tow percentage value is very small ( less or more than 0.00001 ) }

then show me Latter 'X'

Else Show me Letter 'Y' )

can I have some help please..

Re: if statement for tow almost same value

sunny_talwar — Wed, 18 Jan 2017 10:31:32 GMT

May be this:

If(fab(A% - B%) < 0.00001, 'X', 'Y')