Clear content without clear formula

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