Nested If function

**xtcdude** · 06-30-2020, 01:47 PM

Can you please look into the attachment and tell me where am I going wrong? I want my last cell to return 0 when the D is empty.

Thanks in advance

**BadlySpelledBuoy** · 06-30-2020, 02:01 PM

Nested IFs need to be in a specific order depending on how you want it to act.

Try this rearranged version of your formula:

=IF(D4="",0,IF(D4>C4,(D4-C4)*B4,IF(D4<C4,(A4-C4)*B4+D4*B4)))

BSB

**xtcdude** · 06-30-2020, 02:12 PM

Dear BSB,
Thanks for the prompt response. But now with this rearranged version, it is returning 0 for everything. Would you mind re looking at it please

Thanks

**xtcdude** · 06-30-2020, 02:14 PM

Oh my bad,
I had the formula pasted in the wrong cell. It works perfectly fine.
Thank you heaps BSB

**BadlySpelledBuoy** · 06-30-2020, 02:32 PM

Happy to help

BSB

Nested If function

LinkBack

Thread Tools

Rate This Thread

Display

Nested If function

Re: Nested If function

Re: Nested If function

Re: Nested If function

Re: (Resolved) Nested If function

Thread Information

Users Browsing this Thread

Similar Threads

One nested IF function cell shows incorrect value based on another nested IF function

[SOLVED] Nested vlookup or nested IFAND function?

Calling function inside function. (aka nested function)

COUNTIF/COUNTIFS function + nested user-defined function

[SOLVED] Nested Function With Division - Receiving #VALUE! Function Error

[SOLVED] Nested AND function within IF function is only addressing logical1 but not logical2

[SOLVED] Offset function with nested match function not finding host ss.

Bookmarks

Bookmarks

Posting Permissions