Forum Discussion

Prakash_C's avatar
Prakash_C
Copper Contributor
Jan 24, 2021

I need a help

I want a cell (eg. G4) blank or it can take a value based on other cell(eg. F4).

I am writing in G4 =if(F4="","",?) what should i write in place of ? to take the manual entries.

 

excel

6 Replies

  • Wyn Hopkins's avatar
    Wyn Hopkins
    MVP
    Jan 28, 2021

    Hi Prakash_C 

     

    Cell G4 cannot have a formula and be allowed to be typed over (that would erase the formula)

     

    I'd go with JMB17 's approach and have a separate "manual override" cell (e.g. E4)

    • JMB17's avatar
      JMB17
      Bronze Contributor
      Jan 28, 2021

      You could set up a custom function to get user input via input box and use something like:

      =IF(F4="","",GetUserInput())

      But, I've no idea how often excel might trigger it to re-calculate and you'd spend a bunch of time re-inputting the data, so it can technically be done but I wouldn't think it practical.

  • JMB17's avatar
    JMB17
    Bronze Contributor
    Jan 28, 2021
    In these cases, I set up a nearby cell for manual input (say E4), then
    =If(F4="","",E4)
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Jan 24, 2021

    Prakash_C My guess it that it could be

    =IF(F4="","",F4)

    This will leave G4 blank if F4 is blank, otherwise it take whatever value is in F4. 

    • Prakash_C's avatar
      Prakash_C
      Copper Contributor
      Jan 28, 2021

      Riny_van_Eekelen Thanks for the reply, I want Manual entries (User defined) to be taken in False condition. But it takes the value of F4. 

Resources