if and / or
 

col a col b col c
6000
-- 6000
i have a this formula in Col C if(a0,"debit","credit"). however, there are
rows where there is nothing in columns A or B so i want Col C to be blank

thanks in advance for your help

aprilshowers

if and / or
 

Assuming the formula you posted just has a typo, use:

=if(count(a1:b1)<2,"",if(a10,"debit","credit"))

Regards,
Fred

"april" wrote in message
...
col a col b col c
6000
-- 6000
i have a this formula in Col C if(a0,"debit","credit"). however, there
are
rows where there is nothing in columns A or B so i want Col C to be blank

thanks in advance for your help

aprilshowers

if and / or
 

Try this formula for row 2
=IF(A20,"debit",IF(B20,"credit",""))
and fill down.


"april" wrote:

col a col b col c
6000
-- 6000
i have a this formula in Col C if(a0,"debit","credit"). however, there are
rows where there is nothing in columns A or B so i want Col C to be blank

thanks in advance for your help

aprilshowers

if and / or
 

well your solution is certainly a lot simpler than the one i finally came up
with =IF(AND(ISBLANK(D9),ISBLANK(E9))," ",IF(D90,"debit","credit"))

thanks for your help
--
aprilshowers


"JLatham" wrote:

Try this formula for row 2
=IF(A20,"debit",IF(B20,"credit",""))
and fill down.


"april" wrote:

col a col b col c
6000
-- 6000
i have a this formula in Col C if(a0,"debit","credit"). however, there are
rows where there is nothing in columns A or B so i want Col C to be blank

thanks in advance for your help

aprilshowers

if and / or
 

One note, and it was sparked by a comment 'Mike H' made:

you seem to have a (bad) habit if inserting a
space
" " instead of a null string "" for the false condition. As a general rule
it is better to return a NULL string for your false condition.

I agree with him on that, as does David Biddulph, see this discussion:

http://www.microsoft.com/office/comm...b-53a7e400e3b9

As David Biddulph explained in that same discussion:
There is a difference between a space " " and the null string "". Strictly
neither of these is the same as a blank cell, but a test for ="" will return
TRUE for either a blank cell or a cell in which "" is returned by a formula,
so I would support Mike's recommendation that you use "", and not " ".

"april" wrote:

well your solution is certainly a lot simpler than the one i finally came up
with =IF(AND(ISBLANK(D9),ISBLANK(E9))," ",IF(D90,"debit","credit"))

thanks for your help
--
aprilshowers


"JLatham" wrote:

Try this formula for row 2
=IF(A20,"debit",IF(B20,"credit",""))
and fill down.


"april" wrote:

col a col b col c
6000
-- 6000
i have a this formula in Col C if(a0,"debit","credit"). however, there are
rows where there is nothing in columns A or B so i want Col C to be blank

thanks in advance for your help

aprilshowers