corsasport.co.uk
  Not logged in [Login - Register]  
You Are Not Registered Or Not Logged In  

Corsa Sport » Message Board » Off Day » Geek Day » Microsoft Excel » Post Reply

Post Reply
Who Can Post? All users can post new topics and all users can reply.
Icon:
Formatting Mode:
Normal
Advanced
Help
Insert Bold text Insert Italicized text Insert Underlined text Insert Centered text Insert a Hyperlink Insert Email Hyperlink Insert an Image Insert Code Formatted text Insert Quoted text
Message:
HTML is Off
Smilies are On
BB Code is On
[img] Code is On
Post Options: Disable smileys?
Turn BBCode off?
Receive email notification of new replies?

strick206

 posted on 18th Apr 08 at 16:26

One more thing, as it's going to be a spreadsheet with a lot of data inputted, how do i make the formula that is copied down show nothing if no data is entered into the first field

=IF(G4="1st","Yes","No")


strick206

 posted on 18th Apr 08 at 14:51

quote:
Originally posted by blebo
The Yes in the formula needs to be "Yes".

It needs the quotes to show it is a text string.


Thanks, something i should have remembered to be honest


blebo

 posted on 18th Apr 08 at 08:36

The Yes in the formula needs to be "Yes".

It needs the quotes to show it is a text string.


strick206

 posted on 17th Apr 08 at 22:38

Yeah, i thought it would be simple but must be something going wrong somewhere


Robbo

 posted on 17th Apr 08 at 22:36

Possily

cant undertsand why the yes no bit doesnt work... i use simple yes/no ifs daily to clear stuff and never had any problems :S


strick206

 posted on 17th Apr 08 at 22:34

I guess i can do this using VLOOKUP although it will be a little complicated but that should solve the Yes No problem


Robbo

 posted on 17th Apr 08 at 22:31

lol, just makes it a bit easier


strick206

 posted on 17th Apr 08 at 22:30

quote:
Originally posted by Robbo
u used the forumla box?


:lol: Yeah mate, i know excel and used it quite alot up until 3 years ago, all a little vague now but i know that much :lol:


strick206

 posted on 17th Apr 08 at 22:29

If i make the formula what is below, and change the Yes/No for True/False it works, it just won't work with Yes No for some reason, is there a way in which i can convert the True to Yes so it will work, makes it easier for my task


=IF(H6,D6*F6,0)


Robbo

 posted on 17th Apr 08 at 22:29

u used the forumla box?


strick206

 posted on 17th Apr 08 at 22:27

I have just gone through and deleted all merged cells and inputted again using the above, still shows the name

The formula is now

=IF(H6=yes,"D6*F6","0") but still no luck


Robbo

 posted on 17th Apr 08 at 22:22

Deffo should just be =IF(O5=Yes,"G5*K5","0")

Check all the derivitives etc


strick206

 posted on 17th Apr 08 at 22:20

No mate just Yes typed in

I should be able to do it, i think what's causing the problem is the second = in the formula


Robbo

 posted on 17th Apr 08 at 22:16

That should work so summat must be up... is the Yes derived from a formula?


strick206

 posted on 17th Apr 08 at 22:16

That's what i had robbo, but it comes back with #Name?

I think i'll have it sorted if i can change it from searching for TRUE/FALSE to YES/NO


Robbo

 posted on 17th Apr 08 at 22:12

=if(O5=Yes,"G5*K5","0")


strick206

 posted on 17th Apr 08 at 21:59

It's been a few years since i used excel, and i have done part of the calculation i want to do correctly, just cannot grasp it all :(

Here it is, i want a cell to calculate a sum using an IF function

IF Cell O5 is Yes, G5*K5

IF Cell O5 is No, 0

Has anyone use excel regularly and can remember the whole of the if fucntion