Hello,
I have a long if statement which I would like to shorten, I have an idea on how I want to do this but am not sure if it is possible.
In short: I would like to: IF(A1=B1, C1, [value_if_true]*D1)
My [value_if_true], is a long formula and my [value_if_false] is simply multiflying [value_if_true] by another cell/formula. Is it possible to get excel to return [value_if_true] in the [value_if_false] without just duplicating it?
Thanks
I have a long if statement which I would like to shorten, I have an idea on how I want to do this but am not sure if it is possible.
In short: I would like to: IF(A1=B1, C1, [value_if_true]*D1)
My [value_if_true], is a long formula and my [value_if_false] is simply multiflying [value_if_true] by another cell/formula. Is it possible to get excel to return [value_if_true] in the [value_if_false] without just duplicating it?
Thanks