Clear content without clear formula

Closed
a_elgazar Posts 5 Registration date Thursday October 27, 2016 Status Member Last seen November 5, 2016 - Oct 30, 2016 at 07:32 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Oct 30, 2016 at 09:19 AM
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

Related:

1 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Oct 30, 2016 at 09:19 AM
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
0