If And Or?

[mrroboto]

Can you help me determine what is wrong with this?

IF(H8<(0.7*H10),(0.07*H8))
(OR((H8<(0.8*H10)),H8>(0.69*H10)),(0.08*H8))

Basically what I am trying to do is have the worksheet display th
payout based on profit and what % of goal that profit represents. H8 i
the profit (which changes each day) and H10 is the goal (i.e. 100%)
There is a variable payout based on the what % of goal H8 is. Fo
example, if H8 is 60-69% of H10, the payout is 7% of H8, if H8 i
70-79% of H10, the payout is 8%, and so on. Let me know if you nee
more clarification.

Thank

 

[Aladin Akyurek]

Is it something like this?...

=LOOKUP(H8/H10,{0,0;0.6,0.07;0.7,0.08;0.8,0.09;0.9,0.1})*H8

If so, you need to adjust the built-in table
{0,0;0.6,0.07;0.7,0.08;0.8,0.09;0.9,0.1}.

 

[mrroboto]

How do I adjust the built-in table? I did not have a table to begi
with.

Thanks

 

[Aladin Akyurek]

{0,0;0.6,0.07;0.7,0.08;0.8,0.09;0.9,0.1}

is a kind of table. It says:

0 --> 0
0.6 -->0.07 (that is, 60% --> 7%)
etc.

 

[hgrove]

Aladin Akyurek wrote

Is it something like this?...

=LOOKUP(H8/H10,{0,0;0.6,0.07;0.7,0.08;0.8,0.09;0.9,0.1})*H8

If so, you need to adjust the built-in table
{0,0;0.6,0.07;0.7,0.08;0.8,0.09;0.9,0.1}.

...

I'm always wary of division involving user entries. A variation,

=H8*LOOKUP(H8,{0;0.6;0.7;0.8;0.9}*H10,
{0;0.07;0.08;0.09;0.1}

 

[Don]

Not sure if this is what you're after or not, but you can
give it a try.....

=IF(H8<(0.7*H10),(0.07*H8),IF(H8<(0.8*H10),(0.08*H8),IF
(H8>(0.8*H10),(0.08*H8),"")))

Hope I understood what you were trying to do.

Don

 

[mrroboto]

Will this still allow you to use a range, such as 60-69% --> 7%, 70-79
--> 8%, etc.

 

[Harlan Grove]

Will this still allow you to use a range, such as 60-69% --> 7%, 70-79%
--> 8%, etc. ?

Yes. You need to read up on the LOOKUP function and array constants in
online help.

 

[Harlan Grove]

Not sure if this is what you're after or not, but you can
give it a try.....

=IF(H8<(0.7*H10),(0.07*H8),IF(H8<(0.8*H10),(0.08*H8),
IF(H8>(0.8*H10),(0.08*H8),"")))

....

So if H8 is exactly equal to 0.8*H10 (e.g., H8 == 24, H10 == 30), the result
would be "" even though if H8 were just under or just over 0.8*H10 the
result would be 0.08*H8.

 

[mrroboto]

This one worked great! Thanks to everyone for their assitance!