Hi experts,
I need to keep O12 blank if O10 and O11 doesn't have any values at the same time, but if there is a vlue either in O10 or O11, O12 should show the value. ..pls help..
Thanks in advance.
Hi experts,
I need to keep O12 blank if O10 and O11 doesn't have any values at the same time, but if there is a vlue either in O10 or O11, O12 should show the value. ..pls help..
Thanks in advance.
May be this?
=IF(O10<>"",O10,IF(O11<>"",O11,""))
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Maybe I misunderstood, but perhaps this...
=IF(O10+O11=0,"",O10+O11)
Did you mean is both are empty, show nothing (my suggestion), or did you mean if either 1 is empty, show nothing (Six's suggestion)?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thanks FDbbins......
Happy to help, and thanks to both of you for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks