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.
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.