hi, i have attached a excel worksheet for calrity of my formula problem.
When cells B1 and B2 are empty i want the formula (cell D5) to return a True answer, similarly when cells B1 and B2 have data in them i also want it to return a True answer. otherwise return a False answer.
=IF(AND(ISBLANK(B1),ISBLANK(B2)),"true","False")
thats how far i've got with the formula. any help would be very appreciated.
btw this formula will feed into another.
thanks
When cells B1 and B2 are empty i want the formula (cell D5) to return a True answer, similarly when cells B1 and B2 have data in them i also want it to return a True answer. otherwise return a False answer.
=IF(AND(ISBLANK(B1),ISBLANK(B2)),"true","False")
thats how far i've got with the formula. any help would be very appreciated.
btw this formula will feed into another.
thanks