View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BRC BRC is offline
external usenet poster
 
Posts: 10
Default nesting if function question

I am trying to use if function to set number in current cell to be
between 0 and .09 depending on adjacent cell. E. g. value for B1 [if
A1.09,09,A1] but I also want to test for the condition [If A1<0,0,A1]
Can anyone direct me to code that can do this? Thanks in advance for
any suggestions
BRC