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

Hello,
Assuming that you wish G5 to display no information if your other
conditions are not true you can try this.

=IF(G4="","",IF(G4=0,4,IF(G4=1,2,IF(G41,0))))

Regards,

SteveG


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=274153

You can also use:

=if(isblank(G4),"",if(G4.....))

avner


--
Avner
------------------------------------------------------------------------
Avner's Profile: http://www.excelforum.com/member.php...fo&userid=5078
View this thread: http://www.excelforum.com/showthread...hreadid=274153