Forum Discussion
IF function ?
Dear All, I have the following task to solve. I have variable data in one cell which used for further calculation. There are basically only two variants 30 or 60. If the value is 30 the callculat...
This is a difference in style rather than substance.
= 60 * (Value1+Value2) * (1 + (Variable=30))Using 365 it is a dynamic array formula that returns all the results in one spilt range.