IF Statement help

[Arts]

Hi all

I have an IF statememt query

I am currently using the formula

=IF(Workings!M102<1,Workings!M101,Workings!M102)

which is working fine how ever I wanted to incorporate IF M101 < 1 then give me M100

i tried the following

=IF(Workings!M102<1,Workings!M101,IF(Workings!M101<1,Workings!M100,Workings!M101))

but this did not work any help would be much appreciatted

Thanks

 

[VoG]

Try

=IF(Workings!M102<1,IF(Workings!M101<1,Workings!M100,Workings!M101),Workings!M102)

 

[Arts]

God that has annoyed me so much !!

Vog why your formula work and my one didnt (even my other attempt below)???

I even tried

=IF(Workings!M102<1,Workings!M101,if(Workings!M101<1,Workings!M100,Workings!M101),Workings!M102)

I noticed you put your second IF statement in the TRUE part rather than the FALSE

 

[VoG]

It is a matter of getting the logic correct and the parentheses in the right place

=IF(Workings!M102<1

    then 

        IF(Workings!M101<1

              then

        Workings!M100

       else

         Workings!M101)

else

Workings!M102

 

[Arts]

Thank you VoG

I shall go away and study