Forum Discussion
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.
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.
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.
Prakash_C Don't understand, sorry! You can't have a formula in order to enter a value manually.