Formula Help needed

remove the "else " from the formula.

A few other things:

1. Remove the quotes around the numbers, unless you actually want them to be treated as text strings instead of numbers.
2. Instead of nesting this many ifs have a look at one of the LOOKUP functions.
3. You can only have two options for each IF, what to do if true and what to do if false, not 3.

Try:

=IF(AND(G36<500,G5*H5<=200),200,IF((G5*H5>200),G5*H5,""))

Hotpepper if look likes your formula will work but can you help me with the whole thing. Can Take a look at my example and help me write it like yours?

To try to speed things up for you, you should first clarify what you are trying to achieve.

As Hotpepper mentioned each time you mention an IF statement, You have 4 arguments. e.g. your last statement is
If statements only have 3 arguments. i.e. IF(Condition,Result if condition is True, Result if condition is False).

In your statement, it looks like you have 2conditions and 2 results. Perhaps you want both conditions true? So if G36>500000and G5*H5=?,If true return 90.00 else if not true return "No Match".

Please let us know for each If statement, what is(are) the condition(s) you are looking for and what are the IF true and IF false results you want.

This will help you get to your solution, quicker.