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

I have input the following if function

if(at1av1,at1-av1,0) however if the number in av1 is greater than at1 it
returns a negative number, rather than returning 0.

can someone enlighten me as to what I have missed.

thanks