2

I have to write a complex formula like this:

IF(5−SUM(C35:I35)>0,5−SUM(C35:I35),"")

Can I define a variable for 5−SUM(C35:I35)?

  • 1
    I usually create a (hidden) column to calculate complex formula if I need to reuse the result several times. – nohillside Dec 20 '18 at 7:29
2

I think that the best solution would be to just assign your variable formula to a different cell and refer to that one in your main formula.

Example:

Cell A1:

=5−SUM(C35:I35)

Cell B1:

IF(A1>0,A1,"")

You could then hide the column where the variable is, so you don't have to see it.

You must log in to answer this question.

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