Clear content without clear formula [Closed]

Report
Posts
5
Registration date
Thursday October 27, 2016
Status
Member
Last seen
November 5, 2016
-
Posts
1852
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 7, 2020
-
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
1852
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 7, 2020
136
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!