Anybody know of any program or way to pass functions or Excel formula for writing normal??
example:
if 31 is greater than 29 is equal to Yes.
IF (31> 29; "Yes," No ")
Anybody know of any program or way to pass functions or Excel formula for writing normal??
example:
if 31 is greater than 29 is equal to Yes.
IF (31> 29; "Yes," No ")
Last edited by Birnen; 08-31-2010 at 01:30 PM.
Hi, you're almost there
=IF(31>29;"Yes";"No")
If 31 is in cell A1 and 29 is in cell B1, then you can refer to the cells like this
=if(A1>B1;"Yes";"No")
cheers
yes, that I now...
what I won t is a program to write normaly, then the program write's the funtion...
I don't think I understand what you mean. Can you spend some more time on an explanation?
What is the input? What should the output be?
You can't just type a string into a cell & convert it automatically to a Formula.
The nearest option is possibly the button marked "fx", next to the formula bar. This will open the Formula Wizard
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Did this solve your problem? If you are satisfied with the solution(s) provided, please mark your thread as Solved.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks