I am trying to replacate this IF statement in reporting: =IF(I21>0,I21*1.3 E21,I21 E21) — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

I am trying to replacate this IF statement in reporting: =IF(I21>0,I21*1.3 E21,I21 E21)

I am trying to replicate this IF statement from excel to narrative reporting:

=IF(G21>0,G21*1.3+C21,G21+C21)

Of course the "21" refers to a cell in excel, however, I'd like to refer to a column.

When I try IFTHEN([G]>0 ,([G]) * 1.3 + ([C]),[G],[C]), I get an error saying I have a syntax error at or after "(" at the character position 15. What am I doing wrong?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!