- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Google sheets formula help
Posted on 7/25/23 at 7:45 pm
Posted on 7/25/23 at 7:45 pm
I currently have in cell G4 this formula....
=IF(AND(E4>=10,F4>=10),"W","L')
Problem is when I haven't entered any numbers into E4 or F4 it returns a "L" , which starts another formula in K4 cell.
I would like it if E4 and F4 are blank it leaves G4 blank. Thanks for any help
=IF(AND(E4>=10,F4>=10),"W","L')
Problem is when I haven't entered any numbers into E4 or F4 it returns a "L" , which starts another formula in K4 cell.
I would like it if E4 and F4 are blank it leaves G4 blank. Thanks for any help
2
Posted on 7/25/23 at 8:59 pm to H2A2
=IF(ISBLANK(E4),"",IF(AND(E4>10,F4>10,E4>0),"W","L"))
Posted on 7/26/23 at 3:29 am to H2A2
I entered your question in CHAT GPT and got this response. I don't know if the outcome is correct or not. I know excel just enough to be dangerous.
This post was edited on 7/26/23 at 3:31 am
Posted on 7/26/23 at 10:29 am to NCIS_76
From the looks of it, it wouldn't give me "L" when it needs to
Posted on 7/26/23 at 10:34 am to WhiskeyThrottle
This has worked for me, thanks Whiskey
Page 1 of 1
Popular
Back to top
Follow TigerDroppings for LSU Football News