Conditional Expression in cell

T

TPB

How would I put this into a cell as a formula? Other than some graphs,
I'm new to excel. Be gentle with me. :)
***************

IF B33 ISBLANK

AND B34 ISBLANK

THEN B28 EQUALS ZERO

OTHERWISE B28 will show the formula =+b35/728

***************
 
T

TPB

jordun said:
Hi
try: =IF(AND(ISBLANK(B33),ISBLANK(B34)),B28=0,B35/728)

here you're nesting IF with AND function and ISBLANK function.jordun, thank you so much for answering me, and so quickly!

I'm now tasked with doing the quarterly reports and I've inherited a
spreadsheet that has quite a few problems. This resolves one of the
major ones that I didn't know the syntax to. I use MS Access, and Excel
has a lot of differences in syntax.

Thanks again,

TPB
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top