ReoGrid Forum

Navasender

Member

Registered: 2015-06-09

Posts: 10

IF formula

Hi Jing,

I'm having a problem using the IF formula with string in the possible options? e.g. =>   sheet(0, 2) = "=IF(A1=1,'It is the number 1','Other Number')"
Could you send me an example?
Is it possible to nest an IF formula into another IF formula as in Excel?
Thank you

Jingwood

Moderator

From: jing at reogrid.net

Registered: 2014-06-03

Posts: 615

Re: IF formula

Hi Navasender,

Welcome! Please use double quotation instead of single quotation:

C#

sheet[0, 2] = "=IF(A1=1,\"It is the number 1\",\"Other Number\")";

VB.NET

sheet(0, 2) = "=IF(A1=1,""It is the number 1"",""Other Number"")"

ReoGrid will try to support single quotation in the future version.

Yes, nested formula is also supported:

=IF(B9=10, IF(C8=1,"OK","NG"), D8) 

Jing

Last edited by Jingwood (2015-06-10 00:09:19)

Navasender

Member

Registered: 2015-06-09

Posts: 10

Re: IF formula

Perfect Jing.
Thank you very much.