If cell is empty then nothing

[Hjemmet]

Help i need a Formula for checking if 1 one or 2 cell's are Empty

the code i try is this

=IF(OR(L5="";L11=""))

and this code

=IF(L5="";OR(L11=""))

but they aint work

what i want is this solution
If no value in L5 nothing show in Cell "P11"
If no value in L11 nothing show in Cell "P11"

hope that was enough info

 

[MARK858]

What do you want to show in P11 if there is data in both L5 and L11?

 

[DanteAmor]

Try this

=IF(OR(L5="";L11=""),"one cell is empty", "two full cells")

 

[AhoyNC]

Looks like you have a space between your quotation marks. Try deleting them.

=IF(OR(L5="";L11="");"")

 

[Hjemmet]

Sorry i missing that Part

i use it in "conditional formatting" when if "L5" or "L11" or both cell's where empty then "conditional formatting" Change the text color to White in celle "P11"

 

[MARK858]

Then you just need the Or part

=OR(L5="",L11="")

 

[Hjemmet]

Thanks That help a lot

Mark858