Ask Your Question
1

if and if combine then the condition

asked 2017-03-30 23:09:56 +0100

sisihagen gravatar image

Hello,

how can I combine two if commands? This is command for first requirement:

=IF(ISNUMBER(FIND("1";B38));ROUNDUP(B36*1,6/1050)*1050;"0")

But I need the follow chance:

=IF(ISNUMBER(FIND("1";B38)) && =IF(ISNUMBER(FIND("1";B39)) THEN ROUNDUP... else 0

Thank you for advice.

Silvio

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2017-03-30 23:42:43 +0100

karolus gravatar image

Hallo

=IF( AND( ISNUMBER( FIND("1";B38)) ; ISNUMBER( FIND("1";B39)) ) ;  ROUNDUP(B36*1,6/1050)*1050 ; 0 )
edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-03-30 23:09:56 +0100

Seen: 140 times

Last updated: Mar 30 '17