Combing two if/and statements in the same formula

[Godot60]

Hello,

I have two if/and statements that need to be combined in the same cell. Each statement works separately but I cant seem to figure out a way to combine them. Suggestions welcome. Thanks.

=IF(AND(R19<g19,l17="hourly"),(g19 2080),(g19="" 26))

=IF(AND(R19>G19,L17="Hourly"),(R19/2080),(R19/26))</g19,l17="hourly"),(g19>

 

[oldbrewer]

suggest you re state question formulas are screwed - always have a space either side of a "<" or ">" in the formulas you copy paste onto here

 

[Fluff]

Alternatively click Go Advanced > Select HTML off

 

[Godot60]

Re: Combing two if/and statements in the same formulanin

<g19,l17="hourly"),(g19 2080),(g19="" 26))
<g19,l17="hourly"),(g19 2080),(g19="" 26))
I will repost.

</g19,l17="hourly"),(g19></g19,l17="hourly"),(g19>

 

[Godot60]

Combining two if/and statements in the same formula

Hello,

I am trying to combine these two statements in the same formula. Each one works separately but I can't seem to combine them. Any suggestions appreciated.

IF(AND(R19 < G19,L17="Hourly"),(G19/2080),(G19/26))
IF(AND(R19 > G19,L17="Hourly"),(R19/2080),(R19/26))

 

[steve the fish]

Re: Combining two if/and statements in the same formula

You couldnt combine them without more info. For example if L17 doesnt equal Hourly then one formula does one thing and the other does another.

 

[oldbrewer]

Re: Combining two if/and statements in the same formula

IF(AND(R19 < G19,L17="Hourly"),(G19/2080),IF(AND(R19 > G19,L17="Hourly"),(R19/2080),(R19/26)),(r19/2080))you dont need brackets round g19/2080 etc