Hi
I am trying to set up a formula that will look at one cell (DG15) on a worksheet and then take it away from a different cell (AG15) - however if that cell is blank then it will look at a different cell (BT15) and use that to calculate.
this is the formula that I am using at the moment:
=SUM(IF('Data Entry'!AG15=0,(VLOOKUP('Data Entry'!DG15,Formulas!$B:$BW,74,FALSE)-VLOOKUP('Data Entry'!BT15,Formulas!$B:$BW,74,FALSE))),(VLOOKUP('Data Entry'!DG15,Formulas!$B:$BW,74,FALSE)-(VLOOKUP('Data Entry'!AG15,Formulas!$B:$BW,74,FALSE))))
however what this is doing is:
assume AG15 is blank - it this then doing as I ask in the sense that it is taking DG15( 12) - BT15(15) - which produces -3. At this point I want it to give me that answer. However it then goes on to do DG15(12) - AG15(0) = 12 and then does -3 +12 = 9.
When AG15 = a number it does seem to just do the second part of my formula and not the first - which is what I want. It is just the other way round it doesn't seem to work!!
thanks
Bookmarks