G
Gator
Trying to figure out how to write a function for the following issue:
I want to have a cell that reads from another (first) cell the number and
then report action based on the number in the first cell. It needs to
consider first if the cell has a “0†in it should then report a “0â€, If it is
not a “0†it then needs to run the equation “269.9+(9.538*F7)â€. The function
I have at this point is “=IF(D7=0, "0","269.9+(9.538*F7)")†the problem is
that the first part works and it reports “0†as it should but if I put
another number in get the equation printed rather than it running the
equation.
I want to have a cell that reads from another (first) cell the number and
then report action based on the number in the first cell. It needs to
consider first if the cell has a “0†in it should then report a “0â€, If it is
not a “0†it then needs to run the equation “269.9+(9.538*F7)â€. The function
I have at this point is “=IF(D7=0, "0","269.9+(9.538*F7)")†the problem is
that the first part works and it reports “0†as it should but if I put
another number in get the equation printed rather than it running the
equation.