Passing Blank Values

[dmill8023]

Good afternoon all,

Right before the weekend I thought I'd toss this question out. Basically, I have two columns where I have costs. Restaurant 1) is in Column V and Restaurant 2) is in Column X. Sometimes a restaurant will not return a cost, so my IF function of =IF(V9<X9,"A","B") the cell that is blank is the value returned.

Although technically no cost is the lowest cost between the cells it is not the desired logic. This must be simple but please help me build in the parameters to ignore a blank cell.

Thank you!

 

[JoeMo]

If one of cells V9 and X9 is blank or contains "" and the other contains a number, then the MIN function should return the number from the non-blank cell. So,
=MIN(V9,X9)
If both cells are blank this will return 0.

 

[dmill8023]

I am sorry if I was not clear enough. Between V and X I need the lowest cost. The MIN Function selects the right value. My IF function is what's not pulling correct. If X has a cost and V does not, it is saying V is the lowest cost between the two. But, since there is no cost in V it should not be counted and only X should be looked at. Right now if V does not have a cost my IF statement =IF($V8<$X8,"A","B") is returning A but in all actuality should be returning B because it has a cost. Does that make sense?

 

[tom_blamire]

=if(and(v8>1,x8>1),if(v8<x8,v8,if(x8<v8,x8)),"")

 

[tom_blamire]

Apoligies, pressed enter before i finished. The below formula should work:

=IF(AND(V8>1,X8>1),IF(V8<X8,V8,IF(X8<V8,X8)),"")

 

[tom_blamire]

sorry, my computer is playing up:

The formula you need is =IF(AND(V8>1,X8>1),IF(V8<X8,V8,IF(X8<V8,X8)),"")

This will you the lowest value

 

[tom_blamire]

=IF(AND(V8>1,X8>1),IF(V8<X8,V8,IF(X8<V8,X8)),"")

<x8,v8,if(x8<v8,x8)),"")

</x8,v8,if(x8<v8,x8)),"")

 

[Jonmo1]

Put Spaces around the > and < characters.

 

[tom_blamire]

Thanks Jonmo1

=IF(AND(V8 > .1,X8 > .1),IF(V8 < X8,V8,IF(X8 < V8,X8)),"")