Plug Variables into Formula

Formula:
=IF((ISNUMBER(SEARCH("H",F8))),(IF((K8=0),0,IF((K8<505),75,IF((K8<2000),(K8*0.15),IF((K8=2000),(K8*0.2),IF((K8>2000),(K8*0.2))))))),IF((K8=0),0,IF((K8<505),100,IF((K8<2000),(K8*0.15),IF((K8=2000),(K8*0.2),IF((K8>2000),(K8*0.2)))))))


Argument:

(ISNUMBER(SEARCH("H",F8)))

TRUE Then,

(IF((K8=0),0,IF((K8<505),75,IF((K8<2000),(K8*0.15),IF((K8=2000),(K8*0.2),IF((K8>2000),(K8*0.2)))))))

FALSE Then,

(IF((K8=0),0,IF((K8<505),100,IF((K8<2000),(K8*0.15),IF((K8=2000),(K8*0.2),IF((K8>2000),(K8*0.2)))))))


The formula above works but I need to plug in two more variables that are giving me conflicts.
If K8<505 and U8>100 are true Then K8*0.15 must occur and the above argument is bypassed. How can I plug these variables in the same cell.

I'm sorry if I am misunderstanding your request, but if you want K8<505 and U8>100 are true Then K8*0.15 to happen before the rest of your formula, could you write it like this:

=IF(AND(K8<505,U8>100),K8*.15,IF((ISNUMBER(SEARCH("H",F8))),(IF((K8=0),0,IF((K8<505),75,IF((K8<2000),(K8*0.15),IF((K8=2000),(K8*0.2),IF((K8>2000),(K8*0.2))))))),IF((K8=0),0,IF((K8<505),100,IF((K8<2000),(K8*0.15),IF((K8=2000),(K8*0.2),IF((K8>2000),(K8*0.2))))))))

If you are running into a problem with too many nested functions I think you could work from high to low, [IF((K8>2000),(K8*0.2)] first, and not include the [IF((K8=0),0)] ending your formula with just "0" so that if no other criteria are true zero is returned. Unless you have negative numbers in your data, then there is a bit a of a problem.

Thank you matt I will plug this in and see what results i get.