Thread: Function Error?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jackson[_3_] Jackson[_3_] is offline
external usenet poster
 
Posts: 4
Default Function Error?

Hi,

I'm really new to excel and am having a hard time trying to complete an
assignment for my teacher. Could anyone tell me what is wrong with this
formula?

=IF(AND(ISBLANK(F6)),(ISBLANK(G6)),"", (H6+G6-F6))

What I want to do is in a simple accounting worksheet calculate the data
in two individual cells to complete a running balance in a third cell,
but if the first two are empty, I want the third cell to be blank, too.

Thanks.