Forum Discussion
multiple IF in nesting formula
=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 proper...
EDIT: CORRECTION:
I TYPED Y AS IN TRASH, AND IT MARKED AS SOLD.
=IF(D4="X","POSTED",IF(D4>=0.01,"SOLD",IF(D4="","",IF(D4=0,"KEEP",IF(D4="Y","trash")))))
I TYPED Y AS IN TRASH, AND IT MARKED AS SOLD.
=IF(D4="X","POSTED",IF(D4>=0.01,"SOLD",IF(D4="","",IF(D4=0,"KEEP",IF(D4="Y","trash")))))
