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:

Hardware less than $5,000	INCLUDE VALUE
Hardware greater than $5,000	INCLUDE VALUE
Software License <= 1 year	DO NOT INCLUDE VALUE
Software License > than 1 year and $5,000	INCLUDE VALUE
Cloud Service	DO NOT INCLUDE VALUE
Support	DO NOT INCLUDE VALUE
Maintenance	DO NOT INCLUDE VALUE
Training	DO NOT INCLUDE VALUE

<tbody>
</tbody>

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

Hardware less than $5,000	DO NOT INCLUDE VALUE
Hardware greater than $5,000	INCLUDE VALUE
Software License <= 1 year	DO NOT INCLUDE VALUE
Software License > than 1 year and $5,000	INCLUDE VALUE
Cloud Service	DO NOT INCLUDE VALUE
Support	DO NOT INCLUDE VALUE
Maintenance	DO NOT INCLUDE VALUE
Training	DO NOT INCLUDE VALUE

<tbody>
</tbody>

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.