Hello -
I am struggling with a complicated formula. Any help is greatly appreciated.
Calculation intent -
- Look for items in column F that do not contain the letter "X" or a hyphen "-". And. . .
- Look for items in column C that contain the word "Tangible" and sum applicable items in column AG and multiply by defined variable "TaxTan"
- Then add that to ...
- Look for items in column F that do not contain the letter "X" or hyphen "-" And. . .
- Look for items in column C that contain the word "Intangible" and sum applicable items in column AG and multiply by defined variable "TaxIntan"
- Then multiply the total sum by defined variable GA
Here is my stab at it and it is obviously not working.
=IF(AND($F$9:$F$113<>"*X*",$F$9:$F$113<>"-",$C$9:$C$113="Tangible"),SUM($AG$9:$AG$113)*TaxTan,0)+IF(AND($F$9:$F$113<>"*X*",$F$9:$F$113<>"-",$C$9:$C$113="Intangible"),SUM($AG$9:$AG$113)*TaxIntan,0)*GA
Thanks in advance.
Bookmarks