Merging two formulas

[sturnusek]

Hi,

I am trying to put two separate formulas into one, but I am being given a #VALUE ! error in return.

Every single one of them is working fine on it's own, but together there seems to be something wrong.

Code 1

=IF(F2="NO","Not moving","Fast moving")

Code 2

=IF(C2 < DATE(2018,3,30),"Not moving","Fast moving")

Consolidated

=IF(F2="NO","Not moving","Fast moving"),IF(C2 < DATE(2018,3,30),"Not moving","Fast moving")

Anyone has any ideas?

Thanks

 

[RoryA]

What is the logical order of precedence for the calculations? Both of your IF statements are fully self contained at the moment, which is why you can't just join them together.

 

[sturnusek]

RoryA,

I want my formula to check two cells and return me a value. So, if F2 has a 'NO' instead of a number, and C2 is older than 6 months I want it called 'Not moving', or when it's false 'Fast moving'

Sorry about my late reply!

 

[sturnusek]

Just to make it a bit more clear,

I'm trying to make a formula, which will return 'Moving' or 'Not moving' dependent on another value.

So, if item has 'NO' demand, and it's activity is below the six month period based on a specific date (01.04.2018) it will be called a 'Not moving' item.

If item has no demand, but was transacted in the 6 month period it will be called 'Fast moving'.

If an item has a demand, it will be called a 'Fast moving' item regardless of the date.

Activity Demand Item Type
01/10/2017 NO Apple Slow moving
01/10/2018 NO Banana Slow moving
01/10/2017 10 Apple Fast moving
01/10/2018 50 Banana Fast moving

 

[RoryA]

Then I think you want:

=IF(F2="NO",IF(C2 < DATE(2018,3,30),"Not moving","Fast moving"),"Fast moving")

or:

=IF(AND(F2="NO",C2 < DATE(2018,3,30)),"Not moving","Fast moving")