Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formula's
I have designed an excel golf score programme but I want to change how a
formula to show either "1" or a blank instead of "FALSE" or "TRUE"under the following conditions:- if(A3=A4),and(A5<2) I want "1" or else a blank and if(a3=0) I want a blank. Can anyone help please? I am using Excel 2003 Thanks, Fred Golfer |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formula's
Try this:
=IF(A3=0,"",IF(AND(A3=A4,A5<2),1,"")) I think this is what you meant. Hope this helps. Pete On Nov 5, 5:29*pm, Fred Golfer wrote: I have designed an excel golf score programme but I want to change how a formula to show either "1" or a blank instead of "FALSE" or "TRUE"under the following conditions:- if(A3=A4),and(A5<2) I want "1" or else a blank and if(a3=0) I want a blank. Can anyone help please? I am using Excel 2003 Thanks, Fred Golfer |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formula's
Maybe
=IF(A3=0,"",IF(AND(A3=A4,A5<2),1,"")) Mike "Fred Golfer" wrote: I have designed an excel golf score programme but I want to change how a formula to show either "1" or a blank instead of "FALSE" or "TRUE"under the following conditions:- if(A3=A4),and(A5<2) I want "1" or else a blank and if(a3=0) I want a blank. Can anyone help please? I am using Excel 2003 Thanks, Fred Golfer |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formula's
Thanks for the fast response. When I tried it and error was indicated and
the formula slightly changed as follows:- =IF(A3=0,"",IF(AND(A3=A4,A5<2)*1,"")) and the word "FALSE" was displayed. Any idea what it could be?? Thanks again' Fred Golfer "Pete_UK" wrote: Try this: =IF(A3=0,"",IF(AND(A3=A4,A5<2),1,"")) I think this is what you meant. Hope this helps. Pete On Nov 5, 5:29 pm, Fred Golfer wrote: I have designed an excel golf score programme but I want to change how a formula to show either "1" or a blank instead of "FALSE" or "TRUE"under the following conditions:- if(A3=A4),and(A5<2) I want "1" or else a blank and if(a3=0) I want a blank. Can anyone help please? I am using Excel 2003 Thanks, Fred Golfer |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formula's
Just click in the formula bar to edit that formula, and change the *
back to a comma. What error was indicated? Pete On Nov 5, 5:50*pm, Fred Golfer wrote: Thanks for the fast response. *When I tried it and error was indicated and the formula slightly changed as follows:- =IF(A3=0,"",IF(AND(A3=A4,A5<2)*1,"")) and the word "FALSE" was displayed. Any idea what it could be?? Thanks again' Fred Golfer "Pete_UK" wrote: Try this: =IF(A3=0,"",IF(AND(A3=A4,A5<2),1,"")) I think this is what you meant. Hope this helps. Pete On Nov 5, 5:29 pm, Fred Golfer wrote: I have designed an excel golf score programme but I want to change how a formula to show either "1" or a blank instead of "FALSE" or "TRUE"under the following conditions:- if(A3=A4),and(A5<2) I want "1" or else a blank and if(a3=0) I want a blank. Can anyone help please? I am using Excel 2003 Thanks, Fred Golfer- Hide quoted text - - Show quoted text - |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formula's
If you got an error it is presumably because you tried to type in the
formula (and got it wrong) instead of copying the formula from the newsgroup and pasting it into the formula bar. The change you made to the formula is the reason why you got FALSE returned. The original formula given by Pete_UK was correct. [Note also that if you want help it isn't much good just saying "... and error was indicated ...". You'd need to tell us what the error message was.] -- David Biddulph "Fred Golfer" wrote in message ... Thanks for the fast response. When I tried it and error was indicated and the formula slightly changed as follows:- =IF(A3=0,"",IF(AND(A3=A4,A5<2)*1,"")) and the word "FALSE" was displayed. Any idea what it could be?? Thanks again' Fred Golfer "Pete_UK" wrote: Try this: =IF(A3=0,"",IF(AND(A3=A4,A5<2),1,"")) I think this is what you meant. Hope this helps. Pete On Nov 5, 5:29 pm, Fred Golfer wrote: I have designed an excel golf score programme but I want to change how a formula to show either "1" or a blank instead of "FALSE" or "TRUE"under the following conditions:- if(A3=A4),and(A5<2) I want "1" or else a blank and if(a3=0) I want a blank. Can anyone help please? I am using Excel 2003 Thanks, Fred Golfer |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formula's
Thanks for your reply David, You were correct, I had made a typo. The
formula works great. Thanks again, Fred Golfer "David Biddulph" wrote: If you got an error it is presumably because you tried to type in the formula (and got it wrong) instead of copying the formula from the newsgroup and pasting it into the formula bar. The change you made to the formula is the reason why you got FALSE returned. The original formula given by Pete_UK was correct. [Note also that if you want help it isn't much good just saying "... and error was indicated ...". You'd need to tell us what the error message was.] -- David Biddulph "Fred Golfer" wrote in message ... Thanks for the fast response. When I tried it and error was indicated and the formula slightly changed as follows:- =IF(A3=0,"",IF(AND(A3=A4,A5<2)*1,"")) and the word "FALSE" was displayed. Any idea what it could be?? Thanks again' Fred Golfer "Pete_UK" wrote: Try this: =IF(A3=0,"",IF(AND(A3=A4,A5<2),1,"")) I think this is what you meant. Hope this helps. Pete On Nov 5, 5:29 pm, Fred Golfer wrote: I have designed an excel golf score programme but I want to change how a formula to show either "1" or a blank instead of "FALSE" or "TRUE"under the following conditions:- if(A3=A4),and(A5<2) I want "1" or else a blank and if(a3=0) I want a blank. Can anyone help please? I am using Excel 2003 Thanks, Fred Golfer |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formula's
Thanks for your reply Pete, I had made a typo. The formula works great.
Thanks again, Fred Golfer "Pete_UK" wrote: Just click in the formula bar to edit that formula, and change the * back to a comma. What error was indicated? Pete On Nov 5, 5:50 pm, Fred Golfer wrote: Thanks for the fast response. When I tried it and error was indicated and the formula slightly changed as follows:- =IF(A3=0,"",IF(AND(A3=A4,A5<2)*1,"")) and the word "FALSE" was displayed. Any idea what it could be?? Thanks again' Fred Golfer "Pete_UK" wrote: Try this: =IF(A3=0,"",IF(AND(A3=A4,A5<2),1,"")) I think this is what you meant. Hope this helps. Pete On Nov 5, 5:29 pm, Fred Golfer wrote: I have designed an excel golf score programme but I want to change how a formula to show either "1" or a blank instead of "FALSE" or "TRUE"under the following conditions:- if(A3=A4),and(A5<2) I want "1" or else a blank and if(a3=0) I want a blank. Can anyone help please? I am using Excel 2003 Thanks, Fred Golfer- Hide quoted text - - Show quoted text - |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formula's
You're welcome, Fred - thanks for feeding back.
Pete On Nov 5, 8:27*pm, Fred Golfer wrote: Thanks for your reply Pete, I had made a typo. The formula works great. Thanks again, Fred Golfer "Pete_UK" wrote: Just click in the formula bar to edit that formula, and change the * back to a comma. What error was indicated? Pete On Nov 5, 5:50 pm, Fred Golfer wrote: Thanks for the fast response. *When I tried it and error was indicated and the formula slightly changed as follows:- =IF(A3=0,"",IF(AND(A3=A4,A5<2)*1,"")) and the word "FALSE" was displayed. Any idea what it could be?? Thanks again' Fred Golfer "Pete_UK" wrote: Try this: =IF(A3=0,"",IF(AND(A3=A4,A5<2),1,"")) I think this is what you meant. Hope this helps. Pete On Nov 5, 5:29 pm, Fred Golfer wrote: I have designed an excel golf score programme but I want to change how a formula to show either "1" or a blank instead of "FALSE" or "TRUE"under the following conditions:- if(A3=A4),and(A5<2) I want "1" or else a blank and if(a3=0) I want a blank. Can anyone help please? I am using Excel 2003 Thanks, Fred Golfer- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Formula's / Programming | Excel Discussion (Misc queries) | |||
excel formula's | Excel Worksheet Functions | |||
Excel Formula's | Excel Worksheet Functions | |||
Excel Formula's | Excel Worksheet Functions | |||
Excel Formula's | Excel Worksheet Functions |