Thread: IF function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rob Rob is offline
external usenet poster
 
Posts: 718
Default IF function

Hi,

I have a column where some values contain 0 (zero). I want to create an IF
function, where, IF the value is 0 THEN change it to 1, ELSE do nothing (i.e.
retain the original cell value).

Thoughts...

TIA