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
***************
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
***************
Hi
try: =IF(AND(ISBLANK(B33),ISBLANK(B34)),B28=0,B35/728)
here you're nesting IF with AND function and ISBLANK function.
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!Originally Posted by jordun
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks