Forum Discussion
Trying to write a formula
I have a spreadsheet where column A might have a Y or Not.
In column B there is a number.
I would like my formula to say if there is a Y in column A to double the number in column B.
Hi Brian,
With formula you can't take the value from the cell and return into the same cell another value, that's only with macro.