I’m having difficulty with an 'If' formula in Excel. What I want to achieve is, that if a condition in cell A1 is true, then the amount in cell B1 is reduced to zero. This part of the formula is OK. However, if the condition is false I need the amount in cell B1 to remain unchanged. What expression do I need in the formula to let the amount stand?
Let’s assume there’s a value of 100 in cell B1. If the condition in cell A1 is ‘Paid’, I want to reduce cell B1 to zero. However, if there’s no data in cell A1, I want cell B1 to remain unchanged. A number of lines will be utilised in each column and each of these columns will be further analysed and totalled using the ‘SUMIF’ formula.
I do hope this explanation makes a little more sense than my previous thread?
Your explination makes sense however as VoG™ says we'll need to know where B1 gets it's value from originally. If it is just being typed in then you will not be able to do what you are asking. If however it is the sum of another data set then you will be able to create a nested forumla to do what you want.