Help With 2 IF Statements

[WineGuy]

I am trying to enter a double IF statement and can't seem to get more than an error message in Excel.

I need a statement that will produce a result for "If G10 equals "T", then L26/H36 or If G10 equals "G", then (L26/H36)*10%"

Thanks in advance for your help!

[Pete_UK]

Did you try it this way?:

Please Login or Register  to view this content.

You haven't described what happens if G10 is neither "T" nor "G", so this returns "neither". Also, if H36 is zero or blank you will get the #DIV!0 error.

Hope this helps.

Pete

[WineGuy]

You are a genius, Pete. Thanks much!