|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 9th, 2006, 08:42 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
Convert excel formula to access =if(O1N1,N1-O1,0)
Using Access 2003 and trying to convert an excel formulat into Access, but
Access doesn't recognize "then". 
|
|
#2
March 9th, 2006, 08:58 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Convert excel formula to access =if(O1N1,N1-O1,0)
What are you trying to accomplish with this formula and where are you
putting it? What are the field names? What results are you getting and what result do you expect? Details please. -- Rick B "myztical" wrote in message news  Using Access 2003 and trying to convert an excel formulat into Access, but Access doesn't recognize "then".
|
|
#3
March 9th, 2006, 09:08 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Convert excel formula to access =if(O1N1,N1-O1,0)
Are you using the If statement or the IIf statement? (The latter is the
equivalent of Excel's If statement) -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "myztical" wrote in message news Using Access 2003 and trying to convert an excel formulat into Access, but Access doesn't recognize "then".
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Formula Problem - interrupted by #VALUE! in other cells!? | Ted | Worksheet Functions | 17 | November 25th, 2005 05:18 PM |
| How can I convert a formula to a value in excel? | Morgansmummy | General Discussion | 1 | June 29th, 2005 04:22 PM |
| how to convert excel 2000 to access 2000 | W E B G U R L | General Discussion | 1 | January 10th, 2005 03:04 PM |
| pasting Access 02 to Excel 02. numbers dont' work in formula | BXS | Worksheet Functions | 1 | October 4th, 2004 06:33 PM |
Linear Mode
