IF/OR statement

**vicwootn** · 06-20-11, 06:40 AM

IF/OR statement help

oops

**Emily_Haines** · 06-20-11, 06:58 AM

When I copy and pasted found out you had used two of these things........'

you need to use the " which can be done with one key stroke instead.

**vicwootn** · 06-20-11, 07:11 AM

thanks, i think i'm good now :P

**vicwootn** · 06-20-11, 07:11 AM

one more thing, i want to expand upon the following :

=IF(V2<V3,Y5,Y6)

adding IF(V2=V3, 1, 0)

how do i do this?

**trevlyn1983** · 06-20-11, 10:58 AM

will this work ?

Code:

 
=IF(V2=V3,1,IF(V2>V3,0,IF(V2<V3,Y5,Y6)))

**trevlyn1983** · 06-20-11, 10:59 AM

not pasting right
just add the rest of first line to it and see if that works for you .

**jgilmartin** · 06-20-11, 11:10 AM

Look at Example 3 on this page:

Find Microsoft Excel help and learning resources. Explore how-to articles, guides, training videos, and tips to efficiently use Excel.

It is Excel's equivalent to ELSE IF.

**trevlyn1983** · 06-20-11, 11:20 AM

Updated last post.

**vicwootn** · 06-20-11, 11:27 AM

i used what Trev recommended, thanks guys.