LinkBack URL
About LinkBacks
kay123 
I'm struggling with hiding errors and keeping a cell blank if 2 other cells have no data
This works
=IF(C32>=12,L32-(L32*0.1),L32)*C32
But I need to say:
If C32 or C33 = 0 or "", return nothing
Tips / guidance would be a huge help. :-)
I'm struggling with hiding errors and keeping a cell blank if 2 other cells have no data
This works
=IF(C32>=12,L32-(L32*0.1),L32)*C32
But I need to say:
If C32 or C33 = 0 or "", return nothing
Tips / guidance would be a huge help. :-)
Last edited by kay123; 11-11-2011 at 03:43 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks