If And or If Or??

[callahanska]

Trying to write a formula that answers the following:

If x618=TRUE, then M618, else z618*.75 UNLESS M618=0 then z618*.75

Probably super simple for some of you.

Thanks!

 

[BQardi]

Something like this?

=IF(M618=0,Z618*0.75,IF(X618,M618,Z618*0.75))

 

[Michael M]

Try

=IF(AND(X618=TRUE,M618=0),Z618*0.75,M618)

 

[Amanda Wilso]

=IF(M618=0,Z618*0.75,IF(X618,M618,Z618*0.75))
Hope this can help you !