Here is the formula my scatterbrained melon came up with:
=IF(((V17=0)*(N17>=1)),SUM(V17/SUM(N17-P17)),"No P2s")
It's not working, of course.
I would like for Y17 to check the value of V17 and N17. *IF* V = 0 AND N17 >=1, then I wish for v17/sum(N17-P17). If V17 = 0 AND N17< 1 then I would like it to return the text of "No P2s".
:: chomps on pencil ::
Your guidance is appreciated.
~Deirdre
=IF(((V17=0)*(N17>=1)),SUM(V17/SUM(N17-P17)),"No P2s")
It's not working, of course.
I would like for Y17 to check the value of V17 and N17. *IF* V = 0 AND N17 >=1, then I wish for v17/sum(N17-P17). If V17 = 0 AND N17< 1 then I would like it to return the text of "No P2s".
:: chomps on pencil ::
Your guidance is appreciated.
~Deirdre