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
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")
=IF(OR(J6<=3,K6<=3),"Award")
Related:
- Excel Help: IF function using OR, how to make False disappear!
- Excel mod apk for pc - Download - Spreadsheets
- Number to words in excel - Guide
- Kernel for excel - Download - Backup and recovery
- Gif in excel - Guide
- Excel marksheet - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Sep 29, 2014 at 02:44 AM
Sep 29, 2014 at 02:44 AM
=IF(OR(J6<=3,K6<=3),"Award","")
if it is false the cell will be blank.
if it is false the cell will be blank.