If statement

[xxsalahxx]

Hello I am wondering if anyone can help with an if statement, at present I am using the following:

In cell M8 this is my formula =IF(L8<=J8,100%) however I would like to expand this to say if cell K8 has a number then leave cell M8 blank.
Is there a way to do this?
Thanking in advance.

 

[Joe4]

Try this:

=IF(K8<>0,"",IF(L8<=J8,100%))

Note that in your original formula, if L8 > J8, it will return the "FALSE", since you have not provided what to return if the condition is false. If you leave that argument off, it will default to "FALSE".

 

[Fluff]

How about

=IF(ISNUMBER(K8),"",IF(L8<=J8,100%))

 

[ExceLoki]

=IF(K8="",IF(L8<=J8,100%),"")

 

[xxsalahxx]

How about

=IF(ISNUMBER(K8),"",IF(L8<=J8,100%))

Thank you much appreciated.

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[xxsalahxx]

Try this:

=IF(K8<>0,"",IF(L8<=J8,100%))

Note that in your original formula, if L8 > J8, it will return the "FALSE", since you have not provided what to return if the condition is false. If you leave that argument off, it will default to "FALSE".

Thank you, sorry for the late reply