nil

Hi, Is there a way that as a result of an IF statement that 3 cells become merged? IE: IF cell 1A> 2 merge cells 2A, 2B, 2C Else Nil Thanks Aaron

What is happening? OK, fairly familiar with Excel. I have a workbook and in column D I have a formula =IF(AE83=0,"NIL",AE83) for each relevant row. AE83 has formula of =SUM(E83:AC83) Basically I am summing the row. When AE is zero I want to show NIL in column D. This works exactly as...

Hi all I'm trying to do multiple IFs and having problems. The below if in place at the moment, and basically pulls the £'000 value from another location for set parameters - =IF(F$8=1,EntGLActual($C$1,F$3,F$2,F$7,$A12),0)/1000 The output here is set to 1 decimal place, and zeroes showing as...

Hello, The header is the advance filter, where I can select part number from the drop down, and below that is the data with part numbers and the remarks column showing excess and nil stock. When I select the part number in the header from the drop down, I want the NIL STOCK part numbers to...

Hello and thanks for the help in advance. I have been googling and trying to overcome this issue for days and cannot seem to get Index, Match or Lookup formula's to work. I have the following 2 Worksheets in a single Workbook (raw file gets converted and VBA code copies the second sheet in -...

Hi I've got VBA to Autofilter records, and to copy the filtered results to another sheet. When no records are returned, the spreadsheet crashes. Is there any code to identify if the number of records returned is 0, then go to a specific line of code? I couldn't find anything completely...