Forum Discussion

Copper Contributor

Mar 01, 2022

Solved

Formula to add 100 for every 0

In cells F12-J12 if any cells are 0 need 100 for each 0 to be added to L12. Any help would be greatly appreciated.

Formulas and Functions

OliverScheurich
Mar 01, 2022
CassandraMar
=COUNTIF(F12:J12,0)*100
Is this what you are looking for?

5 Replies

OliverScheurich
Gold Contributor
Mar 01, 2022
CassandraMar
=COUNTIF(F12:J12,0)*100
Is this what you are looking for?
- CassandraMar
  Copper Contributor
  Mar 01, 2022
  Thank you! That worked, do you know how to combine the two formulas below?
  
  =L12-K12
  =COUNTIF(F12:J12,0)*100
  - OliverScheurich
    Gold Contributor
    Mar 01, 2022
    CassandraMar
    =COUNTIF(F12:J12,0)*100-K12
    Maybe with this formula if i correctly understand what you want to do.