formula troubles.

  leroy heskey 15:40 11 Jan 2006
Locked

Is there anyway to create a formula with an 'if' value. for example ('if' A1= 3 then C1 = wed, or if A1 = 2 then C1 = tues.

  PaulB2005 15:54 11 Jan 2006

Use a Nested IF

Can't do it now - on way ou, but you have to write the formula so it's in the usual format of

IF X(TRUE, FALSE)

but then put the A1=2 part in the FALSE section and keep going

Example

=IF(I2=0,"£0.00",IF(I2<11,"£1.75",IF(I2<51,"£1.00",IF(I2<101,"£0.75",IF(I2>=101,"£0.50")))))

Works out a pay rate dependant on the the value of I2...

  PaulB2005 15:56 11 Jan 2006

So it would be


=IF(A2=1,"Monday",IF(A2=2,"Tuesday",IF(A2=3,"Wednesday",IF(A2=4,"Thursday",IF(A2=5,"Friday")))))

  PaulB2005 15:56 11 Jan 2006

=IF(A2=1,C1 ="Monday",IF(A2=2,C1 ="Tuesday",IF(A2=3,C1 ="Wednesday",IF(A2=4,C1 ="Thursday",IF(A2=5,C1 ="Friday")))))

  leroy heskey 16:12 11 Jan 2006

cheers for the help. i'll give it a go.

  miles right 20:48 12 Jan 2006

you might also like to try this as part of the formula: add ... if(i2="","",....then formula.
this will keep i2 blank until there is a result to go in it. I use this all the time to keep a spreadsheet unclutter of data.
Miles Right

  VoG II 21:03 12 Jan 2006

=TEXT(A1+1,"dddd")

would save a bit of typing ;o)

  VoG II 21:07 12 Jan 2006

=CHOOSE(A1,"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday")

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Alienware 17 R4 2017 review

These brilliant Lego posters show just what children's imaginations are capable of

Mac power user tips and hidden tricks

Comment réinitialiser votre PC, ordinateur portable ou tablette Windows ?