I am creating a drawer balance sheet for a business. I have one cell, lets assume it is "H11", that will have three conditions which are: 1. greater than zero, 2. equal to zero, and 3. less than zero. What I want to accomplish is I want to have cell "G11" to display different text depending on the condition of h11. For example if H11 is greater that 0 I want G11 to display OVER. If H11 is equal to zero I want G11 to display IN BALANCE. and if H11 is less than zero I want G11 to display SHORT. Any help would be greatly appreciated.