Sum and Countif from two cells
Hi everyone,
I hope you can help with this particular requirement.
I have a formula =IF(AND(F14=3,G14<2)=TRUE,1,"") which is in cell J14
I also want to 'add' to this formula an 'or statement' (I am not sure of the terminology, so taking a shot in the dark).
So it would continue to complete the calculation as normal, but if there is a '1' in K14 it would also output in J14 as a 1
I hope this is making sense.
I hope you can help.
Many thanks in advanced.
Ravi
Last edited by ravisandhu; 04-21-2009 at 09:57 AM. Reason: Solved
Try
=IF(OR(K14=1,AND(F14=3,G14<2)),1,"")
modytrane
Re: Sum and Countif from two cells
Hi Modytrane,
That's terrific, it does what I wanted.
Although it raises another problem, which I will post separately.
Many thanks.
Ravi
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks