|
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
|
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 | |
strick206 |
posted on 18th Apr 08 at 14:51 |
quote: 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". | |
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 | |
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: :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 | |
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 | |
Robbo |
posted on 17th Apr 08 at 22:22 |
Deffo should just be =IF(O5=Yes,"G5*K5","0") | |
strick206 |
posted on 17th Apr 08 at 22:20 |
No mate just Yes typed in | |
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? | |
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 :( |