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.

| improve this answer | |

You must log in to answer this question.

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