Use of IF(OR(

[dgardnerman]

I might have my wires crossed on syntax...
I am trying to get my target cell to function but I get a blank.


=IF(OR(V5="",W5="",X5=""),"",(V5*W5+X5/60*V5))

https://www.dropbox.com/s/1nlp4h1a783mytx/Screen Shot 2018-11-02 at 4.25.29 PM.png?dl=0

 

[rlv01]

Works for me. If I put numbers in V5, W5, and X5, I get a result

 

[dgardnerman]

I may have forgot to mention a step.
I want to to be able to use one or the other or both
So, if I only enter minutes I get a result, or if I only enter hours I get a result.

 

[Michael M]

Ok, so you need a formula for entered hours and a different formula for entered minutes....
maybe something like

=IF(AND(V5<>"",W5<>""), "your hr formula",IF(AND(V5<>"",X5<>""),"your minutes formula",""))

 

[dgardnerman]

Great! that is doing what I want, now I need the hour formula and the minute formula to add together if I use them both, right now it'll only return one value or the other.

 

[Michael M]

What are the 2 formula you are using ??

 

[dgardnerman]

What are the 2 formula you are using ??

=IF(AND(V5<>"",W5<>""), V5*W5,IF(AND(V5<>"",X5<>""),X5/60*V5,""))

this is from the target cell, right now if one is blank it reports the other, I want it to add the two formulas together if I so choose to use both formulas.

 

[Michael M]

=if(and(v5<>"",w5<>""), v5*w5+x5/60*v5,if(and(v5<>"",x5<>""),v5*w5+x5/60*v5,""))

 

[Michael M]

Hmmm.....simpler ???

=IF(V5="","", V5*W5+X5/60*V5)

 

[dgardnerman]

=if(and(v5<>"",w5<>""), v5*w5+x5/60*v5,if(and(v5<>"",x5<>""),v5*w5+x5/60*v5,""))

Perfect! Post #9 didn't cut it. I forgot to add something...
IF(A5="x")

Currently I have this:

=IF(AND,V5<>"",W5<>""), V5*W5+X5/60*V5,IF(AND(V5<>"",X5<>""),V5*W5+X5/60*V5,""))

and it works great! just need to be able to turn it on/off with a trigger from A5