Nested IF formula

Could anyone tell me how to write a nested if formula please?

What I need to write is IF cell f2 is greater than or = 100 and cell g2 is greater than or = 78 then put a 1 in cell h2 if not leave blank.

What I have written but it doesn't seem to like is =IF(AND(F2>="100",G2>="78"),1,"")

Any help would be greatly appreciated.

Worked a treat, thank you so very much

Hi Everyone, this is my first post.

I'm trying to use the IF function to reduce a list of prices by a percentage, with varying percentages based on what the original price is.

My reduction percentages should be as follows:
Under 100 = 9% reduction
Over 100 = 11% reduction
Over 300 = 13% reduction
Over 500 = 16% reduction
Over 1000 = 20% reduction

My starting formula (all original prices are in column A):

=IF(A1>100,(A1*0.89),(A1*0.91))

This works for the over and under 100 percentages, but I can't work out how to add more IF's into the same formula. I've been trying for the last 2 hours to get additional IF's into the same line but I can't get it to work.

I'm no excel wizard. This is the most complicated thing I've ever attempted and could really use someones help!

Thanks in advance!

@mikeskins84

You should read the Forum Rules at the top of the screen. These tell you that you should not ask a question in someone else's thread - rather, you should start your own thread.

Pete

Hi Pete,
Apologies. My logic was to find a thread related to what I'm doing rather than start a fresh. Should have read the rules!