LinkBack URL
About LinkBacks
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.
You need to nest an OR statement into the formula
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Thanks - that got me much further :-)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks