Pls see columns K-Q of "SwingTicketData" tab in attached excel file. It always put 0 eventhough I have deleted the values in C2:F7 on "SwingTicketOrderForm". Pls help. Thanks
Pls see columns K-Q of "SwingTicketData" tab in attached excel file. It always put 0 eventhough I have deleted the values in C2:F7 on "SwingTicketOrderForm". Pls help. Thanks
Hows about =IF(SwingTicketOrderForm!P19="","",IF(SwingTicketOrderForm!$C$2="","",SwingTicketOrderForm!$C$2)) or you could turn the Show Zeros off in the options.
or you can use
if(isblank())
=IF(isblank(SwingTicketOrderForm!P19),"",IF(ISBLANK(SwingTicketOrderForm!$C$2),"",SwingTicketOrderForm!$C$2))
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
very nice! Let me close this case.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks