• 408K Members
• 7,554 Online
• 465K Conversations

New Contributor

# 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

7 Replies

# Re: Formula returns 0

Not sure if I interpreted you correctly

If you are after a logical test to confirm there is a value in C12 and if not do nothing and if correct do the calc, then this will work

=IF(\$C12=0,0,\$C12-\$F\$3)

if not can you explain a little clearer for me

# Re: Formula returns 0

I'm sorry i did not explain myself clearly.

All i'm trying to do is a logical test using the IFS formula I'd like excel to If in C:C finds the number "2,446.96" to make it "600" and then if on G:G it finds a number like "600" to take away 600 from 2,446.96.

I might not be explaining myself rightly, English isn't my first language.

# Re: Formula returns 0

Hi

What are your expected results for G12, G13, G14, etc.?

# Re: Formula returns 0

If any of C:C equals C13, then return F3; then if any of G:G equals F3, retuns -C12-F3.

# Re: Formula returns 0

I meant the real numbers.

For example:

G12 should be 444.

G13 should be 741.

G14 should be -4.

# Re: Formula returns 0

Ok so for now all i'd want is G12 to be DOP RD\$1.846,96

# Re: Formula returns 0

`=IF(COUNTIFS(\$C\$12:\$C\$48,C13),C12-F\$3,)`
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies