# simple formula to display Value

Hello Sir,
I'm trying to write a simple formula to check whether either 1 or 2 table are blank and, if so, leave the resulting to display the value of non-blank table.
I want the resulting table to only display a value if all or either 1 table are filled in.

These are formula I tried.
=IFERROR(C5,OR(H5,AND(M5))) if c blank then shows blank
=IFERROR(C6,AND(H6,OR(M6))) if c blank then shows blank
=IFERROR(M7,OR(H7,OR(C7))) if m blank then shows blank
=IFERROR((C5,H5,M5),IFERROR((H5,M5),IFERROR((C5,M5),(C5))))

Plz help..
LVL 1
###### Who is Participating?

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DirectorCommented:
This looks like excel , remember when you are dealing with empty boxes evaluation , the best way to sort out your problem is to this formula below:

=IFERROR(C5,OR(H5,AND(M5))) if c blank then shows blank

= IF(ISBLANK (C5),"Empty"," Actual Figure")

Your formula is not clear, If I were in your position I will do it like below:

= IF(ISBLANK (C5),0, " actual Figure")

Regards

Chris
Author Commented:
Hi Chris,

Thx for the response, the formula you have suggested is (if C5 is blank to show "0" if not then show "Actual Figure") its a if formula bro :)

what i want to show the available value from the either of tables above as mentioned.

if c5 blank then read h5 if h5 is blank then read m5 - result it shd read either cell & skip the blank.
DirectorCommented:
Okay I see I will back shortly , but confirm whether this is excel or something else because you saying tables
Author Commented:
:) it is excel
DirectorCommented:
Okay but still this can be done through the IF evaluation, try the formula below , just replace with your parameters.

=IF(AND(C2<>"",B2<>""),A2-C2,"")

The above will surely do what you want , I have used your formula but just removed IFERROR factor.

Regards

Chris
Finance AnalystCommented:
Try this:

=IF(C5<>"",C5,IF(H5<>"",H5,M5))

In words:

If C5 is not blank then use C5 otherwise if H5 is not blank then use H5 otherwise use M5

If M5 is also blank the result will be zero because a reference to an empty cell just gives zero. If you don't want zero but want it blank:

=IF(C5<>"",C5,IF(H5<>"",H5,IF(M5="","",M5)))

Thanks
Rob

Experts Exchange Solution brought to you by

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Excel & VBA ExpertCommented:
Try below:
``````=IF(NOT(ISBLANK(C5)),C5,IF(NOT(ISBLANK(H5)),H5,IF(NOT(ISBLANK(M5)),M5,"")))
``````
Author Commented:
HI Rob, thx for help it [code] =IF(C5<>"",C5,IF(H5<>"",H5,IF(M5="","",M5))) [/code] worked..

Hi Shums, thx for your help too its worked as well..

thanks you guys

& Chirs - i m already using that formula for some other worksheet but that is for - calculation - thx anyhow for the help.
Finance AnalystCommented: