Forum Discussion

brian a kennett's avatar
brian a kennett
Copper Contributor
Feb 25, 2018

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.

Formulas & Functions
Need Help
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Feb 25, 2018

    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.

Resources