Hi
I need to write a formula that says:
If cell H1 AND P1 both have something entered in them = False
If cell H1 AND P1 are both BLANK = FALSE
If cell H1 has something entered in it, but P1 is BLANK = TRUE
In the case of a False result, I will be just be returning a basic value, such as "Complete". In the case of a True result I will be running a basic formula (=A1-B1)
Is anyone able to assist me with this please? Many thanks in advance
B
I need to write a formula that says:
If cell H1 AND P1 both have something entered in them = False
If cell H1 AND P1 are both BLANK = FALSE
If cell H1 has something entered in it, but P1 is BLANK = TRUE
In the case of a False result, I will be just be returning a basic value, such as "Complete". In the case of a True result I will be running a basic formula (=A1-B1)
Is anyone able to assist me with this please? Many thanks in advance
B