No value entered

[WannaKooky]

I written a gradebook type of sheet.
However, it's calculating cells with no data as zero (0) and I want th
formula to avoid calculating a cell unless it has data.
Example

(for G5) =IF(G4=0,4,IF(G4=1,2,IF(G4>1,0)))

I want it where only G4 is calculated when it has a value entered.

Thanks

 

[SteveG]

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

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

Regards,

Steve

 

[Avner]

You can also use:

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

avne