Formula not working properly
Hi,
Am Mon, 6 Jan 2014 18:21:00 +0000 schrieb HopsBarley:
This is the formula as it is now...
=IF(((D2-D3)+(D3-D4)+(D4-D5)/3)<D5,"YES", "NO")
your formula is missing a pair of brackets. Try:
=IF((((D2-D3)+(D3-D4)+(D4-D5))/3)<D5,"YES", "NO")
Or a bit shorter but a array formula:
=IF(AVERAGE(D2:D4-D3:D5)<D5,"YES","NO")
Array enter the formula with CTRL+Shift+Enter
Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|