I need (master:A2) ti check TOW:BR2,TOW:BS2 and TOW:CH2 they will be set to off if not clicked on the form that feeds excell. I need it to take what ever one is not off and display that txt in (master:A2) Thanks!!!!
I need (master:A2) ti check TOW:BR2,TOW:BS2 and TOW:CH2 they will be set to off if not clicked on the form that feeds excell. I need it to take what ever one is not off and display that txt in (master:A2) Thanks!!!!
Last edited by detailingking; 02-10-2013 at 10:22 PM.
ITll say Yes if it is clicked in the form so the one that is yes needs to enter on master:A2
HEre is the file.
=IF(Tow!BR2="Off",IF(Tow!BS2="Off",IF(Tow!CH2="Off","TowBoatUS"),"Charge"),"Cash") Thats my code now.....one of those three cells will be yes that one needs to go to (mastersheet!A:2)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks