Pete
12-03-2009, 01:54 AM
Hi
Need two formulas to do the following
1. if cell g6 is less than 60000000 then in cell b6 formula column I6*-1
2. if cell g6 is greater then 60000000 then in cell c6 formula c6=g6
Need two formulas to do the following
1. if cell g6 is less than 60000000 then in cell b6 formula column I6*-1
2. if cell g6 is greater then 60000000 then in cell c6 formula c6=g6