strick206
Member
Registered: 12th Apr 07
Location: Wigan Drives:Integra DC5
User status: Offline
|
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
|
Robbo
Member
Registered: 6th Aug 02
Location: London
User status: Offline
|
=if(O5=Yes,"G5*K5","0")
|
strick206
Member
Registered: 12th Apr 07
Location: Wigan Drives:Integra DC5
User status: Offline
|
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
Member
Registered: 6th Aug 02
Location: London
User status: Offline
|
That should work so summat must be up... is the Yes derived from a formula?
|
strick206
Member
Registered: 12th Apr 07
Location: Wigan Drives:Integra DC5
User status: Offline
|
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
Member
Registered: 6th Aug 02
Location: London
User status: Offline
|
Deffo should just be =IF(O5=Yes,"G5*K5","0")
Check all the derivitives etc
|
strick206
Member
Registered: 12th Apr 07
Location: Wigan Drives:Integra DC5
User status: Offline
|
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
Member
Registered: 6th Aug 02
Location: London
User status: Offline
|
u used the forumla box?
|
strick206
Member
Registered: 12th Apr 07
Location: Wigan Drives:Integra DC5
User status: Offline
|
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)
|
strick206
Member
Registered: 12th Apr 07
Location: Wigan Drives:Integra DC5
User status: Offline
|
quote:
Originally posted by Robbo
u used the forumla box?
 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
|
Robbo
Member
Registered: 6th Aug 02
Location: London
User status: Offline
|
lol, just makes it a bit easier
|
strick206
Member
Registered: 12th Apr 07
Location: Wigan Drives:Integra DC5
User status: Offline
|
I guess i can do this using VLOOKUP although it will be a little complicated but that should solve the Yes No problem
|
Robbo
Member
Registered: 6th Aug 02
Location: London
User status: Offline
|
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
Member
Registered: 12th Apr 07
Location: Wigan Drives:Integra DC5
User status: Offline
|
Yeah, i thought it would be simple but must be something going wrong somewhere
|
blebo
Member
Registered: 18th Apr 02
User status: Offline
|
The Yes in the formula needs to be "Yes".
It needs the quotes to show it is a text string.
|
strick206
Member
Registered: 12th Apr 07
Location: Wigan Drives:Integra DC5
User status: Offline
|
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
|
strick206
Member
Registered: 12th Apr 07
Location: Wigan Drives:Integra DC5
User status: Offline
|
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")
|
