Forum Discussion
Help with if/then function
I'm trying to get a specific word inserted in a cell if a number in another cell is positive, and a different word if the number is negative. ie: if the number in cell B10 is positive (>0), "Wet" would be inserted into cell C10. If the number in cell B10 is negative, "Dry" would be inserted into cell C10.
I know this is very basic for many of you. You help is greatly appreciated.
1 Reply
Robert, yes, that's basic. Simple answer is =IF(B10,"Wet","Dry"). But you forgot what to do with zero. You may do your own exercise with that after the reading of this support page https://support.office.com/en-us/article/IF-function-69aed7c9-4e8a-4755-a9bc-aa8bbff73be2
