|
| 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
August 3rd, 2006, 08:38 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Function with &
I'm having trouble getting the If function to work... A B 1.5 10 4 3 If 2A1, then (A-1)*B If not, then B So the result for row1 above should be 5 ((1.5-1)*10) and row2 should be 3 (3). The following did not work: =IF(2A1, (A-1)*B,B) Neither did: =IF(A2,(A-1)*B,IF(A1,B)) Thanks for the help!!! -- acebrown ------------------------------------------------------------------------ acebrown's Profile: http://www.excelforum.com/member.php...o&userid=36640 View this thread: http://www.excelforum.com/showthread...hreadid=568085 
|
|
#2
August 3rd, 2006, 08:49 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Function with &
=IF(AND(A11,A12),(A1-1)*B1,B1)
-- Kind regards, Niek Otten Microsoft MVP - Excel "acebrown" wrote in message ... | | I'm having trouble getting the If function to work... | | A B | 1.5 10 | 4 3 | | If 2A1, then (A-1)*B | If not, then B | | So the result for row1 above should be 5 ((1.5-1)*10) and row2 should | be 3 (3). | | The following did not work: | =IF(2A1, (A-1)*B,B) | | Neither did: | =IF(A2,(A-1)*B,IF(A1,B)) | | Thanks for the help!!! | | | -- | acebrown | ------------------------------------------------------------------------ | acebrown's Profile: http://www.excelforum.com/member.php...o&userid=36640 | View this thread: http://www.excelforum.com/showthread...hreadid=568085 |
|
|
#3
August 3rd, 2006, 08:54 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Function with &
You need to do it like this: =if(and(condition1,condition2),then,else) /Møller -- c991257 ------------------------------------------------------------------------ c991257's Profile: http://www.excelforum.com/member.php...o&userid=36549 View this thread: http://www.excelforum.com/showthread...hreadid=568085
|
|
#4
August 3rd, 2006, 08:55 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Function with &
=IF(AND(A1,A2),(A-1)*B,B)
Regards Trevor "acebrown" wrote in message ... I'm having trouble getting the If function to work... A B 1.5 10 4 3 If 2A1, then (A-1)*B If not, then B So the result for row1 above should be 5 ((1.5-1)*10) and row2 should be 3 (3). The following did not work: =IF(2A1, (A-1)*B,B) Neither did: =IF(A2,(A-1)*B,IF(A1,B)) Thanks for the help!!! -- acebrown ------------------------------------------------------------------------ acebrown's Profile: http://www.excelforum.com/member.php...o&userid=36640 View this thread: http://www.excelforum.com/showthread...hreadid=568085
|
|
#5
August 3rd, 2006, 08:59 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Function with &
thank you kindly! -- acebrown ------------------------------------------------------------------------ acebrown's Profile: http://www.excelforum.com/member.php...o&userid=36640 View this thread: http://www.excelforum.com/showthread...hreadid=568085
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| numerical integration | integreat | General Discussion | 4 | May 12th, 2006 02:40 AM |
| determine if Excel is open | geebee | General Discussion | 11 | January 20th, 2006 09:25 PM |
| How to modify function | Kevin | General Discussion | 5 | January 4th, 2006 10:12 PM |
| SPELL CURRENCY FUNCTION | Rajesh | Using Forms | 1 | October 1st, 2005 11:04 PM |
| Attaching Code | DS | General Discussion | 2 | August 22nd, 2005 11:21 PM |
Linear Mode
