Jagwarman
asked on
IF AND statement
I am trying to create a formula on a Tab called Static Data that refers to a Tab called International. My formula is:
=IF('International!G27="", IF('Intern ationalChe cklist'!G2 8="",10,5) )
(So I am saying If G27 is Blank and G28 is Blank return the No 10 but if G27 is not blank return the No 5)
My formula returns 10 if both fields are blank but it returns FALSE if either or bot are not blank.
Any assistance greatly appreciated.
=IF('International!G27="",
(So I am saying If G27 is Blank and G28 is Blank return the No 10 but if G27 is not blank return the No 5)
My formula returns 10 if both fields are blank but it returns FALSE if either or bot are not blank.
Any assistance greatly appreciated.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Excellent thank you
ASKER
=IF('International!G27="",
=IF('International'!G27=""