Help for a gumbie!

[Bakayaro]

Hi all,

Sorry to bother you but I'm relatively new to Excel and I'm ripping my hair out trying to work out one of these bloody nested if function thingies.

Here's the drama; in column C I have several different entries, two of which are NQ and US. What I need to do is if in column C it says "US" or AND the amount in column H is greater or equal to 400 then I need column H to show 110. If it is under 400 it must show 0. But if in column C it says "NQ" and the amount in column H is greater or equal to 400 then I need column H to show 165.

Does this make any sense?

I appreciate any assistance you may be able to give me.

 

[Michael M]

Hey Scott
I'll think you'll learn more from hanging around here, than any book you'll ever buy.

I'll try not to be a pest on this forum so often

asking questions is not being a pest... the reason we are all here, is because we want to learn / teach / share knowledge, if you want to see what a pest is, click on the lounge link sometimes, and read some of the posts there, some great fun....all in good humour though.

And a belated, Welcome to the Board !!