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