Formula to check two cells to return a value

[SM mechanic]

Hope this makes sense. I would like a formula that would do this.

If G18 is equal to or greater than E18, and if G20 is equal to or greater than E20, return 500, if both criteria aren't met, return 0

 

[SM mechanic]

Forgot to add, I am using Excel 2007

 

[awoohaw]

TRY:

=IF(AND(G18>=E18,G20>=E20),500,0)

 

[Fluff]

Forgot to add, I am using Excel 2007

No need to mention it, as it's shows that in your profile.

 

[SM mechanic]

That worked perfectly!

Thank you so much

 

[awoohaw]

Happy to help.

Best Wishes!