View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
broro183
 
Posts: n/a
Default Changing Forecast Data to Actual


Hi,
I may have misunderstood, but does this help...

Put your forecast figures in row 1 as normal & in row 2 (you may want
to insert another row) type "=if(A5<0,0,a1)" & format the cell for
pounds.


Hth,
Rob Brockett
NZ
I'm still learning & the best way to learn is to experience...


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=500074