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
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.

Resources