Techy Help: IF Statements in Excel - HotUKDeals
We use cookie files to improve site functionality and personalisation. By continuing to use HotUKDeals, you accept our cookie and privacy policy.
Get the HotUKDeals app free at Google Play

Search Error

An error occurred when searching, please try again!

Login / Sign UpSubmit

Techy Help: IF Statements in Excel

£0.00 @
Need a little help guys. trying to insert a "IF" statement into my worksheet. IF CELL X = P, then CELL Y = YES, OTHEWISE = NO but it seems displaying #name, and i dunno whats up! It is als… Read More
Disco Avatar
8y, 5m agoPosted 8 years, 5 months ago
Need a little help guys.

trying to insert a "IF" statement into my worksheet.

IF CELL X = P, then CELL Y = YES, OTHEWISE = NO

but it seems displaying #name, and i dunno whats up!

It is also possible, to colour cells A-C when Cell Y displays YES!?
Disco Avatar
8y, 5m agoPosted 8 years, 5 months ago
Options

All Comments

(28) Jump to unreadPost a comment
Comments/page:
#1
For the first one, I guess you put the formula in cell Y, something along the lines of =IF(A1=P, "YES", "NO")
(I assume the No was meant to be in Y as well?)
where A1 is your cell X

For the second one, check out conditional formatting (under the format window) - it may be able to do what you want to do.
1 Like #2
=IF(cellX=P,"yes","no") the formula would be wriiten in Cell Y
#3
choc1969
=IF(cellX=P,"yes","no") the formula would be wriiten in Cell Y


you will need to put the p in "P"

conditional formatting for the second one, need any help ask.
#4
greg_68
you will need to put the p in "P"

conditional formatting for the second one, need any help ask.


would it be easier if i sent you the excel file (its on 07 format but can save in 03)
banned#5
Yh conditional formattin for the YES colour change


can send to me too and I can sort out tomoz
#6
In 2003

Highlight cells>Format>Conditional formatting>Cell Value is> Equal to> yes

Format(in pop up)>patterns>yellow>ok>ok
#7
i got the first part working, now for the colour
#8
Disco;3704462
now, the cell where P needs it go, is BL57 AND BM57 MERGED together, does that matter?


have you sent Greg your spreadsheet ? :?
banned#9
Merged cells mate you refer to the first cell in the code
#10
choc1969
have you sent Greg your spreadsheet ? :?


YEA, WHY?

no real date on as the mo, so its ok

its quite hard to work out, but i think im gettting there
#11
Disco;3704619
YEA, WHY?

no real date on as the mo, so its ok

its quite hard to work out, but i think im gettting there


I can't sleep at the mo and would have sorted it tonight for you, but am sure Greg will sort it or ODB. both of them helpful :)

all takes practice, I play with it every day but forget the silliest of things....ie the missing speechmarks for the p in your formula

good luck with your studies :thumbsup:
#12
Choc & ODB, think it's sorted but think there maybe more instalments as with most excel projects.

I'm off now so Choc can help if you are staying up.
#13
no probs hun, give us a shout when needed
#14
greg_68
Choc & ODB, think it's sorted but think there maybe more instalments as with most excel projects.

I'm off now so Choc can help if you are staying up.


you sending me the file back over mate? rep will be added once I get my head around it

right guys, conditional format kinda works in that, I want 8 cells coloured, but only 1 is doing so
#15
Disco
you sending me the file back over mate? rep will be added once I get my head around it

right guys, conditional format kinda works in that, I want 8 cells coloured, but only 1 is doing so


Did you get the file back, sent it about 25 minutes ago.
#16
Disco;3704732
you sending me the file back over mate? rep will be added once I get my head around it

right guys, conditional format kinda works in that, I want 8 cells coloured, but only 1 is doing so


you need to copy the format into all of the cells with the formula in
#17
choc1969
you need to copy the format into all of the cells with the formula in


nar, i dont, look

http://img242.imageshack.us/img242/3316/formatzv1.jpg


I put the P in the bttm right corner, but I want the rest of that section to me the same colour, but it wont let me
#18
pm'd ya
#19
greg_68
pm'd ya


brill, now explain who you do it lol please! thats perfect! :thumbsup::thumbsup::thumbsup:
#20
Disco;3704964
nar, i dont, look

http://img242.imageshack.us/img242/3316/formatzv1.jpg


I put the P in the bttm right corner, but I want the rest of that section to me the same colour, but it wont let me


do you want the cell shading to be pink too......you can just format the fill colour :?
#21
highlight the cells that change colour and follow the instructions in earlier post on how to conditional format. This will show you how i did it.

click on the p cell to see the formula for that.

Gotta go to bed now, will catch up tomorrow mornin if you still need help.
#22
choc1969
do you want the cell shading to be pink too......you can just format the fill colour :?


nar, greg as the idea. now i just need to know how do to it. many thanks to you all who gave assistance. I'm sure I'll be back before the end of the project.

Im hoping to have a front screen button type thing, which would save me click the numerous tabs im want to add :whistling:
#23
greg_68
highlight the cells that change colour and follow the instructions in earlier post on how to conditional format. This will show you how i did it.

click on the p cell to see the formula for that.

Gotta go to bed now, will catch up tomorrow mornin if you still need help.


hang on mate... i click on P but theres no formula? ;-)
#24
Disco
hang on mate... i click on P but theres no formula? ;-)


sorry not the p, the paid/unpaid cell
#25
greg_68
sorry not the p, the paid/unpaid cell


just give =IF(BL59="P","paid","unpaid") but not formatting? anyhoo its ok, off 2 bed so will crack on with it later.. cheers for help so far!
#26
Greg, if i send you the master sheet can you do the whole sheet for me and send it back please..

theres like 52 times it needs doing (ie: 52 weeks of the year) is it timetaking or what?

i tried looking at the formula but cant see it. I need to undertstand it though incase i need to alter the sheet
#27
greg, where we at with this mate.
#28
any joy Greg?

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!