Google sheet help need

[aqeelnokia99]

hi all i am trying to get 5% of upcoming result auto in case of new value entered in Cell C i have try below formula but its not work
=arrayformula(IF(C5:C="","",(D4*1.05)))

 

[ExceLoki]

let me know if this fixes your problem.
=IF(C5:C="","",(D4*1.05))

 

[aqeelnokia99]

let me know if this fixes your problem.
=IF(C5:C="","",(D4*1.05))
View attachment 62491

i know this formula i use array function to formula auto drag in case of add new value