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 02:43 AM.
You need to nest an OR statement into the formula
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
Thanks - that got me much further :-)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks