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

#### Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

#### Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

Top Solution Authors
Top Kudoed Authors
Users online (3,196)