Formula help

[krosado]

if premium is greater than $15k cell =24%commission
if Premium is less than $15k cell=22%
if Premium is blank cell =blank

=IF(Q4<15000,24.5%,IF(Q4>15000,22.5%,IF(Q4="","")))
All blanks are showing 24.5%

 

[Smitty]

Welcome to the Board!

You had the arguments reversed:

=IF(Q4="","",IF(Q4<15000,24.5%,IF(Q4>15000,22.5%)))

Now what if Q4<=0?

HTH,

 

[krosado]

Wonderful!

In this scenerio the Premium (Q) would never be less then $0.

I just tried your formula, and it looks great exept for one cell that is responding False when Q54=9,000 ?

I copy and pasted the formula only.
~~~~~~~~~~~~
Also; ideally I want my equation to be if....

=IF(N4=[ends in b{example GRD1234B}=22.5%
if N4= {example GRD1234A}=24.5%

Is there any way to do that? If not I can use the first formula you have me.

 

[Smitty]

If one cell is acting up then odds are it's that one cell, or one dependent on it. Try checking that cell's format and see if it's different from the others, or copy the cell above it down and see what happens.

As for the second formula you can use something like this:

=IF(RIGHT(N1,1)="B",0.225,0.245)

 

[krosado]

<TABLE dir=ltr border=1 cellSpacing=1 borderColor=#333399 cellPadding=2 width=158><TBODY><TR><TD bgColor=#cc99ff height=20 width="50%">

Payment​

​

​

​

​

​

</TD><TD bgColor=#cc99ff height=20 width="50%">

Paid​

​

​

​

​

​

</TD></TR><TR><TD bgColor=#99ccff height=19 width="50%">

3/27/2011​

​

​

​

​

</TD><TD bgColor=#99ccff height=19 width="50%">

4/7/2011​

​

​

​

​

</TD></TR><TR><TD bgColor=#99ccff height=19 width="50%">

3/28/2011​

​

​

​

​

</TD><TD bgColor=#99ccff height=19 width="50%">

3/29/2011​

​

​

​

​

</TD></TR><TR><TD bgColor=#ff0000 height=19 width="50%">

3/27/2011​

​

​

​

​

​

​

​

​

​

​

</TD><TD bgColor=#99ccff height=19 width="50%">
</TD></TR><TR><TD bgColor=#ff0000 height=19 width="50%">

3/31/2011​

​

​

​

​

​

​

​

​

​

​

</TD><TD bgColor=#99ccff height=19 width="50%">

3/30/2011​

​

​

​

​

</TD></TR><TR><TD bgColor=#99ccff height=19 width="50%">

4/22/2011​

​

​

​

​

</TD><TD bgColor=#99ccff height=19 width="50%">

3/22/2011​

​

​

​

​

</TD></TR><TR><TD bgColor=#ff0000 height=19 width="50%">

4/6/2011​

​

​

​

​

​

​

​

​

​

​

</TD><TD bgColor=#99ccff height=19 width="50%">

3/29/2011​

​

​

​

​

</TD></TR><TR><TD bgColor=#ff0000 height=19 width="50%">

4/7/2011​

​

​

​

​

​

​

​

​

​

​

</TD><TD bgColor=#99ccff height=19 width="50%">

3/29/2011​

​

​

​

​

</TD></TR></TBODY></TABLE>

You are a God send! Can I ask you one more question and my project is complete!

I'm having issues with the Conditional Formulas in Excel 2010.

I want the Payment cell to be red only if the date is greater than Today.
If there is date in the Paid cell, I want the Payment (Red) cell to turn off.

 

[Smitty]

Actually, this really ought to be its own post since it is off topic, but since we're here, try:

=IF(AND(A2>TODAY()),B2="")

 

[krosado]

THANK YOU for all of your help!