I'm in column H and I first want to check the value in column A to determine
if it is over or under 80%
Example:
If the value in column A is 80% or greater, I don't want anything to show up
in column H.
If the value in column A is less than 80% AND column B is <= 1%, show ".5%"
in column H.
If the value in column A is less than 80% AND column B is between 1.1% and
2%, show "1%" in column H.
If the value in column A is less than 80% AND column B is between 2.1% and
3%, show "2%" in column H.
If the value in column A is less than 80% AND column B is = 3.1%, show "3%"
in column H.

Can someone help me with this one? Thanks in advance

Hi KReese,

try on the H column this formula:

=if(a7=80%,"",if(b7<=1%,0.5%,if(and((b7=1.1%),(b 7<=2%)),if(and((b7=2.1%),(b7<=3%)),if((b7=3,1%), 4%)))))

hope it helps
Regards from Brazil
Marcelo



"KReese" escreveu:

I'm in column H and I first want to check the value in column A to determine
if it is over or under 80%
Example:
If the value in column A is 80% or greater, I don't want anything to show up
in column H.
If the value in column A is less than 80% AND column B is <= 1%, show ".5%"
in column H.
If the value in column A is less than 80% AND column B is between 1.1% and
2%, show "1%" in column H.
If the value in column A is less than 80% AND column B is between 2.1% and
3%, show "2%" in column H.
If the value in column A is less than 80% AND column B is = 3.1%, show "3%"
in column H.

Can someone help me with this one? Thanks in advance

Hi again,

I've been noticed that if on the column B you have a value between 1% and
1,1% as 1,05% the formula will return FALSE, so it prudent to update it as:

=if(a7=80%,"",if(b7<=1.09%,0.5%,if(and((b7=1.1%) ,(b7<=2.09%)),if(and((b7=2.1%),(b7<=3,09%)),if((b 7=3,1%),4%)))))

Regards, your feedback will be appreciate
Marcelo


"Marcelo" escreveu:

Hi KReese,

try on the H column this formula:

=if(a7=80%,"",if(b7<=1%,0.5%,if(and((b7=1.1%),(b 7<=2%)),if(and((b7=2.1%),(b7<=3%)),if((b7=3,1%), 4%)))))

hope it helps
Regards from Brazil
Marcelo



"KReese" escreveu:

I'm in column H and I first want to check the value in column A to determine
if it is over or under 80%
Example:
If the value in column A is 80% or greater, I don't want anything to show up
in column H.
If the value in column A is less than 80% AND column B is <= 1%, show ".5%"
in column H.
If the value in column A is less than 80% AND column B is between 1.1% and
2%, show "1%" in column H.
If the value in column A is less than 80% AND column B is between 2.1% and
3%, show "2%" in column H.
If the value in column A is less than 80% AND column B is = 3.1%, show "3%"
in column H.

Can someone help me with this one? Thanks in advance

Thanks for the help Marcelo. I'm closer to the result but there are still a
few missing elements.

The result should either be null (if column A is over 80%) - or be one of
four percents (.5%, 1%, 2%, 3%) based on A being under 80% AND B being
between a certain range. (0 - 1%, 1.1% - 2%, 2.1% - 3%, over 3%)

Using the existing if statement:
A) The only thing that ever appears is .005 or False. (I do not see 1%, 2%
and 3% in the if statement)

B) Any value under 1.09% (including negatives) shows .005. Can you show me
how to make this a range between 0% and 1.09%, rather than just <1.09% so
that negative are removed from the equation?


Hope I have clarified this a little better. Thanks in advance for any
additional help.


"Marcelo" wrote:

Hi again,

I've been noticed that if on the column B you have a value between 1% and
1,1% as 1,05% the formula will return FALSE, so it prudent to update it as:

=if(a7=80%,"",if(b7<=1.09%,0.5%,if(and((b7=1.1%) ,(b7<=2.09%)),if(and((b7=2.1%),(b7<=3,09%)),if((b 7=3,1%),4%)))))

Regards, your feedback will be appreciate
Marcelo


"Marcelo" escreveu:

Hi KReese,

try on the H column this formula:

=if(a7=80%,"",if(b7<=1%,0.5%,if(and((b7=1.1%),(b 7<=2%)),if(and((b7=2.1%),(b7<=3%)),if((b7=3,1%), 4%)))))

hope it helps
Regards from Brazil
Marcelo



"KReese" escreveu:

I'm in column H and I first want to check the value in column A to determine
if it is over or under 80%
Example:
If the value in column A is 80% or greater, I don't want anything to show up
in column H.
If the value in column A is less than 80% AND column B is <= 1%, show ".5%"
in column H.
If the value in column A is less than 80% AND column B is between 1.1% and
2%, show "1%" in column H.
If the value in column A is less than 80% AND column B is between 2.1% and
3%, show "2%" in column H.
If the value in column A is less than 80% AND column B is = 3.1%, show "3%"
in column H.

Can someone help me with this one? Thanks in advance

=IF(A1=80%,"",IF(B13%,3%,IF(B12%,2%,IF(B11%,1% ,.5%))))

HTH
--
AP

"KReese" a écrit dans le message de news:
...
I'm in column H and I first want to check the value in column A to
determine
if it is over or under 80%
Example:
If the value in column A is 80% or greater, I don't want anything to show
up
in column H.
If the value in column A is less than 80% AND column B is <= 1%, show
".5%"
in column H.
If the value in column A is less than 80% AND column B is between 1.1% and
2%, show "1%" in column H.
If the value in column A is less than 80% AND column B is between 2.1% and
3%, show "2%" in column H.
If the value in column A is less than 80% AND column B is = 3.1%, show
"3%"
in column H.

Can someone help me with this one? Thanks in advance

Thanks Ardus. I had to add change it slightly, but it works perfectly.
Thanks again for the help!

"Ardus Petus" wrote:

=IF(A1=80%,"",IF(B13%,3%,IF(B12%,2%,IF(B11%,1% ,.5%))))

HTH
--
AP

"KReese" a écrit dans le message de news:
...
I'm in column H and I first want to check the value in column A to
determine
if it is over or under 80%
Example:
If the value in column A is 80% or greater, I don't want anything to show
up
in column H.
If the value in column A is less than 80% AND column B is <= 1%, show
".5%"
in column H.
If the value in column A is less than 80% AND column B is between 1.1% and
2%, show "1%" in column H.
If the value in column A is less than 80% AND column B is between 2.1% and
3%, show "2%" in column H.
If the value in column A is less than 80% AND column B is = 3.1%, show
"3%"
in column H.

Can someone help me with this one? Thanks in advance