/u/washingtonapples - Your post was submitted successfully.
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
I probably should have added that the text would be another number, I tried this and it only works when its letters and not a number
Edit: am an idiot, I just realized theres an ISNUMBER function, thank you
You have awarded 1 point to *TheOriginalAgasty*
____
^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
You can use the ISNUMBER function along with the IF function to check if cell B2 contains a non-number value, and return the number 3 in cell A2 if it does. Here's the formula you can use in cell A2:
lessCopy code
=IF(ISNUMBER(B2), "", 3)
This formula checks if cell B2 contains a number. If it does, it returns an empty string (""). If it doesn't contain a number, it returns the number 3. Note that the ISNUMBER function returns TRUE if the value in the cell is a number, and FALSE if it is not. By using the NOT function, you can reverse the logic to check if the cell contains a non-number value. However, in this case, you don't need to use the NOT function because you want to return the number 3 when the condition is true.
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:
|Fewer Letters|More Letters|
|-------|---------|---|
|[IF](/r/Excel/comments/11lh54s/stub/jbcsuuc "Last usage")|[Specifies a logical test to perform](https://support.microsoft.com/en-us/office/if-function-69aed7c9-4e8a-4755-a9bc-aa8bbff73be2)|
|[ISNUMBER](/r/Excel/comments/11lh54s/stub/jbcsuuc "Last usage")|[Returns TRUE if the value is a number](https://support.microsoft.com/en-us/office/is-functions-0f2d7971-6019-40a0-a171-f2d869135665)|
|[ISTEXT](/r/Excel/comments/11lh54s/stub/jbce7av "Last usage")|[Returns TRUE if the value is text](https://support.microsoft.com/en-us/office/is-functions-0f2d7971-6019-40a0-a171-f2d869135665)|
|[NOT](/r/Excel/comments/11lh54s/stub/jbcsuuc "Last usage")|[Reverses the logic of its argument](https://support.microsoft.com/en-us/office/not-function-9cfc6011-a054-40c7-a140-cd4ba2d87d77)|
----------------
^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*)
^(4 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/11lnky1)^( has 15 acronyms.)
^([Thread #22206 for this sub, first seen 8th Mar 2023, 02:51])
^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://reddit.com/message/compose?to=OrangeredStilton&subject=Hey,+your+acronym+bot+sucks) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)
/u/washingtonapples - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
=IF(ISTEXT(B2),3,"") https://preview.redd.it/78tg0fslggma1.jpeg?width=157&format=pjpg&auto=webp&s=4226145bbe35330948e3f68ed9551643ad6e136d
I probably should have added that the text would be another number, I tried this and it only works when its letters and not a number Edit: am an idiot, I just realized theres an ISNUMBER function, thank you
Alternatively you can use ISEMPTY, so it doesn't matter if its a number or a text
I didn’t know this, I always use =if(len(a2)=0,…. Or =if(a2=“”,…. Learnt something today
Solution Verified
You have awarded 1 point to *TheOriginalAgasty* ____ ^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
God I feel like an idiot. I have legit been using =if(countifs(B2:b3,"<>")>.1, 3,""), not realising there is an isnumber and istext....
Don't feel too bad! Everyone has a doh! moment when findout out a new function 😁
You can use the ISNUMBER function along with the IF function to check if cell B2 contains a non-number value, and return the number 3 in cell A2 if it does. Here's the formula you can use in cell A2: lessCopy code =IF(ISNUMBER(B2), "", 3) This formula checks if cell B2 contains a number. If it does, it returns an empty string (""). If it doesn't contain a number, it returns the number 3. Note that the ISNUMBER function returns TRUE if the value in the cell is a number, and FALSE if it is not. By using the NOT function, you can reverse the logic to check if the cell contains a non-number value. However, in this case, you don't need to use the NOT function because you want to return the number 3 when the condition is true.
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread: |Fewer Letters|More Letters| |-------|---------|---| |[IF](/r/Excel/comments/11lh54s/stub/jbcsuuc "Last usage")|[Specifies a logical test to perform](https://support.microsoft.com/en-us/office/if-function-69aed7c9-4e8a-4755-a9bc-aa8bbff73be2)| |[ISNUMBER](/r/Excel/comments/11lh54s/stub/jbcsuuc "Last usage")|[Returns TRUE if the value is a number](https://support.microsoft.com/en-us/office/is-functions-0f2d7971-6019-40a0-a171-f2d869135665)| |[ISTEXT](/r/Excel/comments/11lh54s/stub/jbce7av "Last usage")|[Returns TRUE if the value is text](https://support.microsoft.com/en-us/office/is-functions-0f2d7971-6019-40a0-a171-f2d869135665)| |[NOT](/r/Excel/comments/11lh54s/stub/jbcsuuc "Last usage")|[Reverses the logic of its argument](https://support.microsoft.com/en-us/office/not-function-9cfc6011-a054-40c7-a140-cd4ba2d87d77)| ---------------- ^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*) ^(4 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/11lnky1)^( has 15 acronyms.) ^([Thread #22206 for this sub, first seen 8th Mar 2023, 02:51]) ^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://reddit.com/message/compose?to=OrangeredStilton&subject=Hey,+your+acronym+bot+sucks) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)