cancel
Showing results for
Did you mean:
Helper II

## Shown number

Hello,

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

Thanks,

1 ACCEPTED SOLUTION

Accepted Solutions
Super User

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.

5 REPLIES 5
Super User

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.

Helper II

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.

Super User

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.

Helper II

Thank you @eka24

I tried your code and it worked.

Helper II

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

Announcements

#### Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

#### Power Apps Community Call

Please join us on Wednesday, January 19th, at 8a PDT. Come and learn from our amazing speakers!

#### Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (2,856)