Ken Johnson Wrote:
Hi Craig,

I'm struggling a bit...

Does this sound right?

You've got a formula in column AX eg AX3
"=H3+N3+P3+V3+X3+AD3+AF3+AM3+AR3"
and you would like column AX to show "NO" if AZ is not blank.

If I'm right then you could change the formula in AX3 to...


=IF(AZ<"","NO",H3+N3+P3+V3+X3+AD3+AF3+AM3+AR3)

If I've not got it right then one possibility is, if at all possible,
email a copy of the sheet to me. My account is a gmail account so it's
just kencjohnson before the @ and gmail.com after the @.

Also, the formula =IF(OR(AY30),AY3,"") doesn't need the OR part,
=IF(AY30,AY3,"") should work.

Let me know how it goes.

Ken Johnson

Hi Ken,

After I sent my previous message ‘across the world’ to you, I started
to ‘play it around’ to find the function that I would like it to work.

However I have managed to find the function but it looks bit ‘long and
heavy to read’, by the way, I have changed around the columns just to
make easy to read with other information for the others…..here we go….

Column D
=IF(OR(J3+P3+R3+X3+Z3+AF3+AH3+AO3+AT3=0),IF(OR(J3 +P3+R3+X3+Z3+AF3+AH3+AO3+AT3=1),IF(OR(BA3=""),1, 0)))

It will show ‘FALSE’ so I have hidden it and use the next column E

Column E
=IF(ISNUMBER(D3),D3,0)


And it worked well; perhaps I sent you a copy of sheet to you?

Cheers

Craig;)


--
craig@help
------------------------------------------------------------------------
craig@help's Profile: http://www.excelforum.com/member.php...o&userid=36201
View this thread: http://www.excelforum.com/showthread...hreadid=563166