View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peach Peach is offline
external usenet poster
 
Posts: 1
Default repeating values

I have this formula to calculate my value balance:
=IF(ISBLANK($C5),$O4-$D5*$L5,$O4+$C5*$L5)

This works but when I copy my formula down the column I get repeating values
for blank cells.

What I want to do is "" is c5 is blank and if it isn't blank I want to do
either of the other formulas.
Can i have two = if to do this?