I written a gradebook type of sheet.
However, it's calculating cells with no data as zero (0) and I want the
formula to avoid calculating a cell unless it has data.
Example
(for G5) =IF(G4=0,4,IF(G4=1,2,IF(G41,0)))
I want it where only G4 is calculated when it has a value entered.
Thanks.
--
WannaKooky
------------------------------------------------------------------------
WannaKooky's Profile:
http://www.excelforum.com/member.php...o&userid=15934
View this thread:
http://www.excelforum.com/showthread...hreadid=274153