Forum Discussion

francescol's avatar
francescol
Copper Contributor
Jan 02, 2019

Excel IFS formula

Hi there, 

 

I have a question about IFS formula. Can it be used to identify if a cel has any value and if so make it to apply a division formula to that cel? 

BI & Data Analytics
Excel on Mac

2 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jan 02, 2019

    Nope, in general any formula in Excel can't take the cell value and return result into the same cell. That's with macro.