nested if statements

  • Thread starter Thread starter dave glynn
  • Start date Start date
D

dave glynn

I have three possible values for any given cell. I am trying to use "&if" but
am getting garbage.

I would like to say =if(b4=1, c5 &if b4=2, c6 &if b4=3,0)

Can anyone point me in the right direction

Many thanks

Dave
 
I have three possible values for any given cell. I am trying to use "&if" but
am getting garbage.

I would like to say =if(b4=1, c5 &if b4=2, c6 &if b4=3,0)

Can anyone point me in the right direction

Many thanks

Dave
Click to expand...

B4? C5? Cell?
Sounds like Excel to me, not Access.

You have posted this question to the wrong newsgroup.
The access in this groups title refers to Microsoft Access, a database
program.
Please repost to the correct newsgroup for the Excel program you are
using.
I would suggest you include your Windows and Office version number in
your message. It might make a difference.
 
Dave -

You can nest the IF statements:


=if(b4=1, c5, if(b4=2, c6 ,0))

No need to test for the b4=3 if it is the only other choice as that 'else'
portion is 0.
 
Back
Top