0

IF statement with in an =NL formula

Jet Reports Historic Posts

August 07, 2010 02:34

None

Follow

Is it possible to use an excel =IF statement within an =NL formula?

My current NL formula is cell J8

=NL("Sum","Job Planning Line","Total Cost","Document No.",$F8,"Cost Category","Material","Line Type","Schedule")

What I would like my IF statement to do is read the column beside cell J8 and if it is blank, return 0.00 and if it is not blank return the value of my NL formula. I do not know how to insert the IF formula into my NL formula.

Any assistance would be greatly appreciated.

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Jet Reports Historic Posts August 08, 2010 20:36

  Hi there
  
  I think this should work….
  
  =IF(I8="",0,NL=("Sum","Job Planning Line","Total Cost","Document No.",$F8,"Cost Category","Material","Line Type","Schedule"))
  
  If I8 equals blank [""], insert 0 otherwise insert the NL function result.

• 0
  
  Jet Reports Historic Posts August 09, 2010 18:01

  Thanks so much. It works perfectly and now I know the structure to use for any other IF statements.
  
  Very much appreciated!

• 0
  
  Nathan July 12, 2018 13:13

  I tried to use the same format but I am having a little bit more of an issue. You will also see the NP("Formula") in the beginning because I am using Table Builder. Please also not I am using ; instead of , because of the European Excel format.

  =NP("Formula";"=IF([@[Traffic Flow]]=""FCL"";0;NL=(""LinkSum"";""Goods Registration Task Line"";""Total Volume""))")

  Result after running the reporting is as follows:

  =IF([@[Traffic Flow]]="FCL";0;NL=("LinkSum";"Goods Registration Task Line";"Total Volume"))

  I look forward to hearing where I may be going wrong.