EXCEL heeeeelp please - HotUKDeals
We use cookie files to improve site functionality and personalisation. By continuing to use HUKD, you accept our cookie and privacy policy.
Get the HUKD app free at Google Play

Search Error

An error occurred when searching, please try again!

Login / Sign UpSubmit
Expired

EXCEL heeeeelp please

mrsj2008 Avatar
6y, 6m agoPosted 6 years, 6 months ago
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<=AA4,"YES","NO")

Thank you
mrsj2008 Avatar
6y, 6m agoPosted 6 years, 6 months ago
Options

All Comments

(3) Jump to unreadPost a comment
Comments/page:
1 Like #1
=IF(B1=A1,"same",IF(B1>A1,"yes","no"))
#2
Thank you so much, you're a life saver:thumbsup:
#3
:thumbsup: no probs

Post a Comment

You don't need an account to leave a comment. Just enter your email address. We'll keep it private.

...OR log in with your social account

...OR comment using your social account

Thanks for your comment! Keep it up!
We just need to have a quick look and it will be live soon.
The community is happy to hear your opinion! Keep contributing!