Excel Help: IF function using OR, how to make False disappear!

[Closed]
Report
Posts
1
Registration date
Sunday September 28, 2014
Status
Member
Last seen
September 28, 2014
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
So I'm writing an excel formula based on Award placings in a race using the IF and OR function. I have the formula correct but I don't want anything thats false to say "False", I would like it to appear blank! Here is the formula I have! If anyone can help thank you!

=IF(OR(J6<=3,K6<=3),"Award")

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
=IF(OR(J6<=3,K6<=3),"Award","")

if it is false the cell will be blank.