# 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?
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
0
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.
0
DirectorCommented:
Okay I see I will back shortly , but confirm whether this is excel or something else because you saying tables
0
Author Commented:
:) it is excel
0
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
0
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
1

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.

Distinguished Expert - 2017Commented:
Try below:
=IF(NOT(ISBLANK(C5)),C5,IF(NOT(ISBLANK(H5)),H5,IF(NOT(ISBLANK(M5)),M5,"")))
1
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.
1
Finance AnalystCommented:

Another option, if only one of the three cells will be populated:

=MAX(C5,H5,M5)
1
###### It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.