Shown number

[DeemaEmadaldin]

Hello,

Currently I'm using If statement but I'm getting zeros before and after the number same as the figure. 

Thanks,

[eka24]

Please paste the full formula.
Do yo know the expect the output?

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Consider Checking My Youtube Channel

[DeemaEmadaldin]

Thanks for replying @eka24 

Actually, I have a data base table in the excel sheet and the only way to insert these values by writing if statement based on my choices.

The formula is If(DataCardValue395.Selected.Value ="1.5" && DataCardValue396.Selected.Value ="Schneider",1041, false) &
If(DataCardValue395.Selected.Value ="2.2" && DataCardValue396.Selected.Value ="Schneider", 1193
, false)& If(DataCardValue395.Selected.Value ="3" && DataCardValue396.Selected.Value ="Schneider",1347, false)

based on my choices in the first 2 data card i should get the number.

[eka24 · Accepted solution]

Try this:

If(DataCardValue395.Selected.Value ="1.5" && DataCardValue396.Selected.Value ="Schneider",1041,
If(DataCardValue395.Selected.Value ="2.2" && DataCardValue396.Selected.Value ="Schneider", 1193,
If(DataCardValue395.Selected.Value ="3" && DataCardValue396.Selected.Value ="Schneider",1347,false)))

Please what is the purpose of the false in the statement?

Also if the code doe not work, show a sample of the Table

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[DeemaEmadaldin]

Thank you @eka24 

I tried your code and it worked.

[DeemaEmadaldin]

Hi @eka24 ,

I'm trying to convert the below table into if statement code, when I added the Delta code to Schneider  it gave me zeros. Is there anyway I can link between the codes or should I write it as one code without separation.Brands tableIf statement code