Clear content without clear formula

[Closed]
Report
Posts
5
Registration date
Thursday October 27, 2016
Status
Member
Last seen
November 5, 2016
-
Posts
1944
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 26, 2021
-
Hello,

i have cells contain formula say ( $e$10 = $e$8+$e$7)

i need to clear e10 if e7 = 10

but formula still found when auto fill to next row

1 reply

Posts
1944
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 26, 2021
145
a_elgazar, Good morning.

I don't know if I understood well your necessity.

Try to use:

E10 -->
=IF(E7=10, "", SUM(E7:E8))

Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão