Forum Discussion

android1's avatar
android1
Post Patron
10 years ago
Solved

IF Custom Column Formula > 1.5

Hi,

 

I'm looking to replace all values in Actual Hours with the values in Scheduled Hours only if the value in Actual is > 1.5 times the size of the Scheduled value. Trying this> if[Actual Hours]*1.5>[Scheduled Hours]then[Actual Hours]=[Scheduled Hours] but getting token error at the end.

 

android1

Need Help
  • android1's avatar
    android1
    10 years ago

    That's perfect Eric. That is exactly what I needed. Thank you.

     

     

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    I think you need the else 

     

    if[Actual Hours]*1.5>[Scheduled Hours]then[Actual Hours]=[Scheduled Hours] else [Actual Hours]

     

    HTH

    Raven