Thread: Redirecting a formula in an "IF THEN" statement
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eden397 Eden397 is offline
external usenet poster
  
Posts: 40
Default Redirecting a formula in an "IF THEN" statement
Hi,
I have a formula in cell K2980 stating "=IF(G2980=0,1,"")" . This works
fine but I need to go further with the formula and don't know how. What I
want to do is if G2980 =0, then I want a 1 to show up in K2980 but I also
want the 0 in G2980 to change to a 1. Is this too circular? Thanks, Eden 397
Reply With QuoteReply With Quote