Combine IF statments

[ABBA]

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 · Accepted solution]

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

[ABBA]

Suvrutt_Gurjar:

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], “”)

Thank you SO much

[Suvrutt_Gurjar]

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