Prev: Time Format Question
Next: Finding next number in a series
From: Max on 13 May 2010 13:27
Maybe this suffices, test it out:
=IF(OR(H6="F",H14="F",H18="F"),"F",IF(OR(H6="P",H14="P",H18="P"),"P",""))
--
Max
Singapore
---
"KL" wrote:
> Max you are awesome! I have to ask was I even close to being on the right
> track with the formula I had come up with?
>
> Ok so my next, and I believe last question, is how do I ignore if the cell
> is blank?
>
> For example:
>
> H1 would use the formula:
> =IF(OR(H6="F",H14="F",H18="F"),"F",IF(AND(H6="P",H14="P",H18="P"),"P",""))
>
> But say H6=P, H14=P, but H18=NT (or blank). Currently the formula gives a
> calue of Blank. But I need it to be able to result a P, as the blank would be
> ignored.
>
> The same would happen if H6=F, H14=P, and H18=NT (blank). The result would
> be H1=F, the blank in H18 would be ignored.
>
> Does that make sense? I do appreciate your help. I am pretty good at
> figuring out formulas in excel but I have been at a loss for this one.
>
> Karen :)
From: KL on 13 May 2010 16:15
Max, Thank you so much for your help! I appreciate it immensely. Karen :)
First  |  Prev  | 
Pages: 1 2
Prev: Time Format Question
Next: Finding next number in a series