Solved: if formula

[Pete]

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

[rbrhodes]

Hi,

Here's what you asked for. I'm sure theres more. <g>

B6: =IF(G6<60000000,I6*-1,"")

C6: =IF(G6>60000000,G6,"")

[Pete]

thanks rhoedes