The IF formula I have is as follows:
=IF(F9>=2,"Low",IF(F9=1,"Medium",IF(F9="Nothing","High",IF(ISBLANK(F9)," ",))))
The function is still auto-filling the cell as "Low" even though I have "Nothing" written in the cell.
At first, instead of "Nothing" I had 0 in the formula, however, it ignored the IF(ISBLANK... function and still auto-filled everything as "High". If there's a way to fix this, please let me know.
Last edited by kyber; 08-12-2021 at 03:13 PM.
Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.
Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.
To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Well, first, " " doesn't give you an null value … you need "". Try:
Formula:
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Try This
=+IF(F9="Nothing","High",IF(F9>=2,"Low",IF(F9=1,"Medium","")))
when you are entering "Nothing", the value of that cell automatically go above 2, which would then satisfy the first condition in your formula and returns the result "low". since the condition is met, excel will not look further into "value if false" condition and hence it will not consider the last part of the formula. the IF formula is doing exactly what its supposed to, its the conditions you give in that require correction.
Last edited by Abith; 08-12-2021 at 04:13 AM. Reason: Cell Reference Correction
Delete delete..
@Richard Buttrey Understood. I'll do that in the future.
@TMS This actually worked! Thank you so much! And I did try "" instead " " and didn't make a different before.
@Abith It didn't work out. When the cell is empty it auto-filled all the cells to "High" for the priority.
Kyber, according to the formula i had mentioned, if the cell is empty, the formula will also return and empty cell as the result. if the cell has the word NOTHING in it, then it would return the result as High. i just want to know where it went wrong
@Abith: to be fair, I tested your formula and it produced the same results as mine. And I think mine has some redundancy.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks