Numeric Search(> or <) with Match

[priyarane]

hi Community,

Is there any way to use Numeric Search(> or <) with Match , I am trying to search like

if(value>0,'T',value<0,'p') as test

so is there any way to use match in above if condition.

-Priya

[Anil_Babu_Samineni]

But What are the T and P in your statement?

[jonathandienst · Accepted solution]

If the conditions are mutually exclusive:

=If(value > 0, 'T', 'p')

Or, if not:

=If(value > 0, 'T', If(value < 0, 'p'))

Or use Match like this:

=Pick(Match(-1, value > 0, value < 0), 'T', 'p')