IF function with Time duration Closed

Question

Hello, 
 I dont understanding why this can't work :

=IF((g2=timevalue("0:30"));"25)

G2 has a time duration time unit in it which equals 0:30.  I am trying to show that if something lasted 30 minutes I need another cell to say that it will cost 25 

Thank you


Configuration: Mac OS X (10.10.5) / Chrome 47.0.2526.111

ac3mark · Answer

Your syntax is wrong in multiple areas.  There is a comma delimiter, not a colon, and you have no end quotes.

Try this:
 =IF((g2=timevalue("0:30")),"25","BLANK")

that syntax is correct.

ac3mark · Answer

It is possible to nest if statements.  It can get messy.  I am certain there is a cleaner way,  I just never had to expand beyond two or three choices.

The nested if looks like this:
=if(logic_test,if(logic_test#2,true,false),false)

I hope this helps.  If you are satisfied, mark it as solved!  Thanks and HAVE FUN!

IF function with Time duration

2 responses

Similar discussions

Subscribe To Our Newsletter!