Groups
    EXPIRED

    EXCEL heeeeelp please

    Hi,

    Please can you help me, i've tried for ages to work a formula but can't do it.

    I want the formula to work out - if AA4 is more than x = 'yes', if less than = 'no' or if no change = 'same'.

    I can get the yes/no bit but can't get the last bit. Can anyone explain it to me?

    =IF(W4
    Thank you

    3 Comments

    =IF(B1=A1,"same",IF(B1>A1,"yes","no"))

    Original Poster

    Thank you so much, you're a life saver:thumbsup:

    :thumbsup: no probs
    Post a comment
    Avatar
    @
      Text
      Top Discussions
      1. Magazine competitions - Issue 39 @ tvchoicemagazine.co.uk55
      2. Win 1 of 3 x £1000 Selfridges vouchers with Virgin Trains109
      3. Win a Free minion usb stick1010
      4. totalev.com comp - win an electric car2121

      See more discussions