Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
using IF & AND
I am trying to get "1" to display in a cell if the value of L4 is 1, and the
sum of M4 & P4 is 0.(if this is false i want nothing to display). I got as far as the following formula, but can't quite seem to get it to work. Thanks if anybody can tell me the adjustment i need to make =IF(=AND(L4=1,=SUM(P4,M4)=0))=1,1,"") |