Can anyone help me sort this IF/Countif formula
Hi
I have problem with this formula in which its work fine for cells that contain values and return result accordingly (24 & 18) but I am trying to find a way for its not to return any result at all (leave the cell blank) if the targeted cell is blank
The current formula i have is
=IF(COUNTIF(N2,">=3334"),"24","18")
can anyone help???
Thank you very much
Nat
welcome to the forum, Nat. try:
=IF(N2="","",IF(COUNTIF(N2,">=3334"),"24","18"))
you actually don't need countif too if it's just a single cell
=IF(N2="","",IF(N2>=3334,"24","18"))
and if you want the results in numbers, don't put the double quotes on 24 & 18
=IF(N2="","",IF(N2>=3334,24,18))
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
self deleted
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
Thank you very much
I am learning excel atm, so many formula and confusion lol
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks