Conditional Expression in cell
 

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

***************


--
TPB
------------------------------------------------------------------------
TPB's Profile: http://www.excelforum.com/member.php...o&userid=33160
View this thread: http://www.excelforum.com/showthread...hreadid=529766

Conditional Expression in cell
 

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

here you're nesting IF with AND function and ISBLANK function.


--
jordun


------------------------------------------------------------------------
jordun's Profile: http://www.excelforum.com/member.php...o&userid=33118
View this thread: http://www.excelforum.com/showthread...hreadid=529766

Conditional Expression in cell
 

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

here you're nesting IF with AND function and ISBLANK function.


--
jordun


------------------------------------------------------------------------
jordun's Profile: http://www.excelforum.com/member.php...o&userid=33118
View this thread: http://www.excelforum.com/showthread...hreadid=529766

Conditional Expression in cell
 

jordun Wrote:
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


--
TPB
------------------------------------------------------------------------
TPB's Profile: http://www.excelforum.com/member.php...o&userid=33160
View this thread: http://www.excelforum.com/showthread...hreadid=529766