When Nothing is Entered

  • Thread starter Thread starter WannaKooky
  • Start date Start date
W

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
 
WannaKooky said:
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.
Click to expand...

Since it is a gradebook type of sheet, it can be assumed that al
entries will be greater than zero. Being so, here is a suggestion (i
may not be elegant, but it will work).

In G5, =if(G4="","",if(G4=0,4,if(G4=1,2,0))
 
Back
Top