Link to home
Start Free TrialLog in
Avatar of Jagwarman
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('InternationalChecklist'!G28="",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.
Avatar of Jagwarman
Jagwarman

ASKER

correction to the above

=IF('International!G27="",IF('InternationalChecklist'!G28="",10,5)) Should read



=IF('International'!G27="",IF('International'!G28="",10,5))
ASKER CERTIFIED SOLUTION
Avatar of zorvek (Kevin Jones)
zorvek (Kevin Jones)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Excellent thank you