Formula Help

  • Thread starter Thread starter Lou
  • Start date Start date
L

Lou

Good Day!
Friday Blues here, I have a report that has a label
([Text30]) that reports percentage of revenue, I am
creating another label that I want to read the percentage
and assign a value,
If it is 90 to 100% = 1
If it is 100 to 110% = 2
If it is 110 to 120% = 3

what would the formula for this be???????

Thank you.
Lou
 
Lou said:
Good Day!
Friday Blues here, I have a report that has a label
([Text30]) that reports percentage of revenue, I am
creating another label that I want to read the percentage
and assign a value,
If it is 90 to 100% = 1
If it is 100 to 110% = 2
If it is 110 to 120% = 3

what would the formula for this be??
Click to expand...

You could have a bunch of nested IIf functions, but this may
be a little easier:

=Switch(Text30 Between .9 And 1, 1, Text30 Between 1 And
1.1, 2, Text30 Between1 1.1 And 1.2, 3)
 
Is this code or formula, I am not familiar to how you have
typed it out..

Thank you.
Lou
-----Original Message-----
Lou said:
Good Day!
Friday Blues here, I have a report that has a label
([Text30]) that reports percentage of revenue, I am
creating another label that I want to read the percentage
and assign a value,
If it is 90 to 100% = 1
If it is 100 to 110% = 2
If it is 110 to 120% = 3

what would the formula for this be??
Click to expand...

You could have a bunch of nested IIf functions, but this may
be a little easier:

=Switch(Text30 Between .9 And 1, 1, Text30 Between 1 And
1.1, 2, Text30 Between1 1.1 And 1.2, 3)
Click to expand...
 
Thank you Marsh,
Actually figured it out and the formula worked like a
champ.

TY
Lou
-----Original Message-----
Lou said:
Good Day!
Friday Blues here, I have a report that has a label
([Text30]) that reports percentage of revenue, I am
creating another label that I want to read the percentage
and assign a value,
If it is 90 to 100% = 1
If it is 100 to 110% = 2
If it is 110 to 120% = 3

what would the formula for this be??
Click to expand...

You could have a bunch of nested IIf functions, but this may
be a little easier:

=Switch(Text30 Between .9 And 1, 1, Text30 Between 1 And
1.1, 2, Text30 Between1 1.1 And 1.2, 3)
Click to expand...
 
Back
Top