Forum Discussion

boJob's avatar
boJob
Copper Contributor
May 13, 2020

Use formula depending on cell input

Hello,

 

I al trying to create a new excel sheet where I want the cell to use a formula when the user did not input a number and to ignore the formula when the user has input a number. Hopefully I have explained it right.

 

Kind regards,

boJob

excel
Formulas and Functions

3 Replies

  • wumolad's avatar
    wumolad
    Iron Contributor
    May 13, 2020

    Hi boJob 

     

    You can use a formula to achieve this, however, you will need to provide additional information to know what you want the formula to do.

     

    if you can share a sample data, it will be useful.

     

    Cheers

    • boJob's avatar
      boJob
      Copper Contributor
      May 13, 2020

      wumolad

      I want the cell to use this formula "=C3*B13" when the user hasn't put any data in, otherwise I want it to use the data the user has put in for example "400". Hope this helps

      • wumolad's avatar
        wumolad
        Iron Contributor
        May 13, 2020
        ok. Because you didn't indicate the cell where the user input will be and where the formula will be, I will assume the following.

        The user input is in cell A1 and the formula is written in cell A2, then you can use this formula:

        =IF(A1="",C3*B13,A1)

        Cheers

Resources