Combine IF statments

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]),
)
,"")

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 “”

2 Likes

Thank you SO much

1 Like

You are welcome. Please do test well per your requirement.

1 Like