Solved: Combine IF statments - Page 2

ABBA · 09-28-2020 08:13 AM

Hi All
I am trying to combine these 2 IF statements

IF(([Tank or Gauge Name]=“25293”),
IFS(
([Previous Day].[Total-Inches]> [Total-Inches]),
([Previous Day].[Oil-Bbls]-[Oil-Bbls]),
)
,"")

IF(([Tank or Gauge Name]=“11955”),
IFS(
([Previous Day].[Total-Inches]> [Total-Inches]),
([Previous Day].[Oil-Bbls]-[Oil-Bbls]),
)
,"")

Suvrutt_Gurjar

I believe you could try

IF( AND(OR( [Tank or Gauge Name]=“25293”, [Tank or Gauge Name]=“11955”) , [Previous Day].[Total-Inches]> [Total-Inches]) , [Previous Day].[Oil-Bbls]-[Oil-Bbls], “”)

If result is numeric , may be you will need to have NUMBER("") or DECIMAL("") in place of last “”

View solution in original post