0

My current formula is =IF(ISBLANK(J2),M2*AB2, IF(J2>1, AC2))

Important to note my formula in M2 is =IF(ISBLANK(L2),"",L2-G2)

AB2=250    AC2= 550

The code runs as G2 gets a delivery date If J2 is blank and L2 has a date, M2 will multiply the amount of days by a dollar amount from AB2. If J2 has a date and L2 does not then the dollar amount from AC2 will calculate. this runs correctly but my value if both J2 and L2 are empty is #VALUE.

I want to put in a statement that solves the value. If both J2 and L2 are blank the value is 0. While keeping the other statements.

The attempts i have tried result in "there are too many arguments".

TLDR:

G2 has a date. If J2 and L2 are blank the value is zero. If J2 has a date and L2 does not then the value is AC2. If J2 does not have a date and L2 does than M2*AB2

Excel formula:

Excel formula

Improve this question
1
  • 2
    Your first formula IF(J2>1, AC2) is perhaps missing an "else" value.
    – harrymc
    Commented Dec 29, 2022 at 15:16

1 Answer 1

Reset to default
0

Please check the formula =IFS(AND(J2="",L2=""),"",AND(J2<>"",L2=""),AC2,AND(J2="",L2<>""),M2*AB2)

Improve this answer
1
  • Yes this solved it thank you !
    – Christina
    Commented Dec 30, 2022 at 14:23

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .