Incentive Forumla

**bhager** · 01-10-2013, 12:41 PM

Hello! I need help with finding a formula for my attached spreadsheet.

This is pretty time sensitive, so any help that you can provide would be greatly appreciated.

Thanks!
Brian

**Moo the Dog** · 01-10-2013, 12:56 PM

You could try this:

=IF(C6>1,1.1*A7*C5,VLOOKUP(C6,H2:I7,2,0)*A7*C5)

- Moo

**bhager** · 01-10-2013, 01:02 PM

It worked!! You are awesome, thank you so much!
Brian

**Moo the Dog** · 01-10-2013, 01:04 PM

Glad to help.

- Moo

**sbehera** · 01-10-2013, 01:08 PM

can use the below if you want to have any value which is less than 95%..
enter in J3

=IF(ISERROR(IF(C6>1,1.1,IF(C6<0.95,0,VLOOKUP(C6,H2:I7,2,0)))),"Check the %",IF(C6>1,1.1,IF(C6<0.95,0,VLOOKUP(C6,H2:I7,2,0))))

AND

Enter in G7

=IF(ISERR(J3*A7*C5),"Check %",J3*A7*C5)