Jan 31 2021 10:03 PM
=IF(H20=x,"trash",IF(H20="","",IF(H20=0,"keep", IF(H20>0.01,"sold"))))
I am working on my budget, however, I wanted to set 3 "keys" in cell H20, however, this will not allow me to function properly the way I am expecting it to do, so I believe that what I typed in the function, are wrong.
When I type x, it will pop the word up in a cell "trash"
When I type 0, it will pop up the word in a cell "keep"
when I leave the a cell blank, it will leave a cell blank,
when I type a number that are above 0.01, it will pop the word up in a cell "sold"
Can you help, please?
Jan 31 2021 10:28 PM - edited Jan 31 2021 10:31 PM
The only issue I see, based on your description, is that the x should be in quotes:
=IF(H20="x","trash",IF(H20="","",IF(H20=0,"keep", IF(H20>0.01,"sold"))))
And, perhaps, if it is possible the value could be 0.01 then you may need a false argument for the last if statement (or change > to >=)?
Feb 01 2021 12:16 AM
Feb 01 2021 12:19 AM
Feb 01 2021 06:54 AM
Feb 01 2021 08:07 AM