formula troubles.

  leroy heskey 15:40 11 Jan 06

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


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



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

  PaulB2005 15:56 11 Jan 06

So it would be


  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


would save a bit of typing ;o)

  VoG II 21:07 12 Jan 06


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…