Thread: Formula Help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chris Chris is offline
external usenet poster
 
Posts: 788
Default Formula Help

Hi All
I have a cell that I need to return a value that is either 10% more if
another cell = 0 or 10% less if < 0. eg B53 =10 then C53 = (C38*10%) and
add to C38 or if B53= -10 then C53= (C38*10%) and take From C38. B53 = 10,
C38 = 16.10 then C53 should = 17.71 or B53 = -10, C38= 16.10 Then C53 should
= 14.49 (C38 less 10%)
Thanks
Chris