Hi I hope someone can help me with the following formula:
=IF(Details!B7,COLLECT,0,Carriage!$J$35)
If Details!B7 has COLLECT in the cell the carriage cost is 0, If Details!B7 has any other text in the cell the cost is Carriage!$j$35. I hope that makes sense...
Thanks!
Bookmarks