formula troubles.

  leroy heskey 15:40 11 Jan 06
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 06

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 06

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 06

=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 06

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

  miles right 20:48 12 Jan 06

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 06

=TEXT(A1+1,"dddd")

would save a bit of typing ;o)

  VoG II 21:07 12 Jan 06

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

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

The Legend of Zelda Breath of the Wild review: Five hours with Zelda on the Nintendo Switch

1995-2015: How technology has changed the world in 20 years

How the painting-like animated sequences in A Monster Calls were created by Glassworks Barcelona

The 22 best Safari extensions | Best Safari plugins: Improve Apple's Safari web browser with these…