I have a spreadsheet in which I have a IF statement which provides specific values when it's true and another if it's false. However, I only want to see the false outcome in the cell if the value is a negative number. I'm sure this is super easy for someone else, however as a novice, it's kicking my behind. I have attached the spreadsheet example. The cell I am formatting are starting with E35 based on the value in cell E29. If the value in cell E29 is a negative I want to see that value in E23, if the value in cell E23 is 0 or a positive number I just want to see 0. Thanks for any assistance!Attachment 282309
disregard the workbook ss and use only Angie's ss for this problem!
Bookmarks