formula assistance

[JohnE]

I have a cell (Z165) that is to have the the amt from cell
M165 multiplied by cell P165. But, that only is true if
there is an "X" in any of the 4 cells I161 thru I164. I
am not able to get a formula to work this. I can do the
formula listing one cell but not with all four. Can
someone assist?
Thanks.
*** John

 

[Rodney POWELL]

John -- try something like this ...

=IF(OR(I161="X", I162="X", I163="X",I164="X"),M165*P165,"")


Hope it Helps,

- Rodney POWELL
Microsoft MVP - Excel

Beyond Technology
Spring, Texas USA
www.BeyondTechnology.com



I have a cell (Z165) that is to have the the amt from cell
M165 multiplied by cell P165. But, that only is true if
there is an "X" in any of the 4 cells I161 thru I164. I
am not able to get a formula to work this. I can do the
formula listing one cell but not with all four. Can
someone assist?
Thanks.
*** John

 

[Bob Phillips]

=IF(COUNTIF(I161:I164,"X")>0,M165*P165,"")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Rodney POWELL]

John ...

I'd use Bob's solution -- more concise and better.

- Rodney POWELL




=IF(COUNTIF(I161:I164,"X")>0,M165*P165,"")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)