Multiple IF Statement - Correction

**RoscoW88** · 11-16-2020, 11:25 AM

Afternoon All,

Can somebody please advise where I am going wrong with the below formula

IF(AND(C6=0,D6=0),"None",if((C6>0,D6=0),"Weight","Box"))

I cant seem to crack it....

Thanks
Ross

**Pepe Le Mokko** · 11-16-2020, 11:31 AM

Perhaps

Formula:

Please Login or Register  to view this content.

**RoscoW88** · 11-16-2020, 11:44 AM

Fantastic - Thank You!

**Pepe Le Mokko** · 11-16-2020, 11:59 AM

You're welcome

Multiple IF Statement - Correction

LinkBack

Thread Tools

Rate This Thread

Display

Multiple IF Statement - Correction

Re: Multiple IF Statement - Correction

Re: Multiple IF Statement - Correction

Re: Multiple IF Statement - Correction

Thread Information

Users Browsing this Thread

Similar Threads

How to easily set up an IF THEN statement that spans multiple cells and multiple sheets

IF Statement with Multiple Conditions and Multiple True/False Results

nested IF statement or AND? trying to write an IF statement with multiple conditions

[SOLVED] If statement that will look among multiple criteria and generate a statement

[SOLVED] Nested if statement correction

[SOLVED] IF statement correction regarding dates

I need to edit and press enter on multiple cells to accept suggested error correction

Bookmarks

Bookmarks

Posting Permissions