I need help with an IF(AND) Function. Here's my Formula: =IF(AND(C8>=0,C9>=0),Just Do It,No Way)
Cell C8 and C9 both have a 0 in them. I've tried changing the values in C8 & C9 to .5 but still get the same result.
I get a #NAME? Return. What did i do wrong?
Last edited by GeeWhiz04; 03-23-2017 at 11:10 AM. Reason: solved
Hi,
You just need quotes around your text values
=IF(AND(C8>=0,C9>=0),"Just Do It","No Way")
Don
Please remember to mark your thread 'Solved' when appropriate.
=IF(AND(C8>=0,C9>=0),"Just Do It","No Way")
What results are you expecting?
if either values are less than 0, you will get "No way", otherwise "Just do it"
Thanks, I knew it was something simple and should have realized i forgot the " marks. Thanks again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks