Forum Discussion

DarlingMESA's avatar
DarlingMESA
Copper Contributor
Feb 27, 2019

Formula returns 0

The formula in cell G12 is giving me a 0. I've tried everything and still can fix the formula. Any ideas?   https://1drv.ms/x/s!ArKKIl4JpMqRzW9qnM8bJMk87u66
Excel Online
Formulas and Functions
training
DarlingMESA's avatar
DarlingMESA
Copper Contributor
Feb 28, 2019
If any of C:C equals C13, then return F3; then if any of G:G equals F3, retuns -C12-F3.
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Feb 28, 2019

I meant the real numbers.

For example:

G12 should be 444.

G13 should be 741.

G14 should be -4.

 

  • DarlingMESA's avatar
    DarlingMESA
    Copper Contributor
    Feb 28, 2019
    Ok so for now all i'd want is G12 to be DOP RD$1.846,96



    • Detlef_Lewin's avatar
      Detlef_Lewin
      Silver Contributor
      Feb 28, 2019
      =IF(COUNTIFS($C$12:$C$48,C13),C12-F$3,)

Resources