Complicated IF AND OR statement

[bryanhope]

Hello, I am trying to create a rule for capitalizing the correct value of IT assets for accurate accounting and depreciation purposes.

Here are the conditions:

IF the asset and is a composite asset meaning built from multiple pieces AND/OR:

[TABLE="width: 522"]
<tbody>[TR]
[TD]Hardware less than $5,000[/TD]
[TD]INCLUDE VALUE[/TD]
[/TR]
[TR]
[TD]Hardware greater than $5,000[/TD]
[TD]INCLUDE VALUE[/TD]
[/TR]
[TR]
[TD]Software License <= 1 year[/TD]
[TD]DO NOT INCLUDE VALUE[/TD]
[/TR]
[TR]
[TD]Software License > than 1 year and $5,000[/TD]
[TD]INCLUDE VALUE[/TD]
[/TR]
[TR]
[TD]Cloud Service[/TD]
[TD]DO NOT INCLUDE VALUE[/TD]
[/TR]
[TR]
[TD]Support[/TD]
[TD]DO NOT INCLUDE VALUE[/TD]
[/TR]
[TR]
[TD]Maintenance[/TD]
[TD]DO NOT INCLUDE VALUE[/TD]
[/TR]
[TR]
[TD]Training[/TD]
[TD]DO NOT INCLUDE VALUE[/TD]
[/TR]
</tbody>[/TABLE]

OTHERWISE IF asset is not a composite asset then the values to capitalize would include:

[TABLE="width: 522"]
<tbody>[TR]
[TD]Hardware less than $5,000[/TD]
[TD]DO NOT INCLUDE VALUE[/TD]
[/TR]
[TR]
[TD]Hardware greater than $5,000[/TD]
[TD]INCLUDE VALUE[/TD]
[/TR]
[TR]
[TD]Software License <= 1 year[/TD]
[TD]DO NOT INCLUDE VALUE[/TD]
[/TR]
[TR]
[TD]Software License > than 1 year and $5,000[/TD]
[TD]INCLUDE VALUE[/TD]
[/TR]
[TR]
[TD]Cloud Service[/TD]
[TD]DO NOT INCLUDE VALUE[/TD]
[/TR]
[TR]
[TD]Support[/TD]
[TD]DO NOT INCLUDE VALUE[/TD]
[/TR]
[TR]
[TD]Maintenance[/TD]
[TD]DO NOT INCLUDE VALUE[/TD]
[/TR]
[TR]
[TD]Training[/TD]
[TD]DO NOT INCLUDE VALUE[/TD]
[/TR]
</tbody>[/TABLE]

Any help would be very much appreciated.

Thanks

 

[Robby19]

Please provide a sample of how the data is actually laid out in your current spreadsheet. This will allow others, including myself, to provide you better support.