Previous Topic Next Topic

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

Closed
daraiuculano Posts 1 Registration date Sunday September 28, 2014 Status Member Last seen September 28, 2014 - Sep 28, 2014 at 06:02 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 29, 2014 at 02:44 AM
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")
Related:

1 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Sep 29, 2014 at 02:44 AM
=IF(OR(J6<=3,K6<=3),"Award","")

if it is false the cell will be blank.
0

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses