Excel IF formula

[uksoundz]

Hi folks,

I'm really struggling with a piece of formula. I need a formula which will display either a 25, 50, 75 or 100 (these being percentages, but just need to be displayed as values) based on whether the data in A1 is equal to or less than 25% (for 25) between 25 and 50% (for 50) between 51 and 75% (for 75) 76%+ (for 100) of the figure in A2.
Does that make sense, I'm not very proficient in excel, or in explaining myself, can anyone help with a formula to work this out?

Thanks,

[Paul]

Hi Uksoundz, welcome to the forum.

You can use a LOOKUP function for this, like so:

=LOOKUP(A1,{0,.26,.51,.76},{25,50,75,100})

[galvinpaddy]

Any chance of a sample sheet you are working with?
EDIT - nevermind, Paul beat me to it

[uksoundz]

Thanks for the quick responses, how do I get this to reference the data in A2? So it looks at the data in A1 and works out the % of A2 and displays the 25,50,75,100 dependent on this.

Thanks again !!!

[Paul]

Ah, I thought this formula was going into A2. If I'm correct, it looks like you want to determine A1 as a percentage of (divided by) A2, e.g. 27/58 is 46.5%, so you'd want to show 50.. if that's the case try adjusting the LOOKUP function from A1 to A1/A2:

=LOOKUP(A1/A2,{0,.26,.51,.76},{25,50,75,100})

[uksoundz]

That works perfectly Paul, thanks very much for your help!