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