Forum Discussion

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

JMB17

Bronze Contributor

Jan 28, 2021

In these cases, I set up a nearby cell for manual input (say E4), then
=If(F4="","",E4)