Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you add figure with a word in?
Hello, Can anyone 'in the know' advise how to add cell1 + cell2 + cell3 and get a numerical result when cell3 may contain a word. Cell3 represent postage and the word, if the order value is is high enough, would be FREE. It's not easy as it looks, it seems! Thank you. Ian -- ianonline ------------------------------------------------------------------------ ianonline's Profile: http://www.excelforum.com/member.php...o&userid=34279 View this thread: http://www.excelforum.com/showthread...hreadid=552764 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you add figure with a word in?
I just did a quick test of adding three cells 10,FREE,5 and the summed answer
was 15 which is as expected. I assume that FREE means it would be equal to a zero value. What kind of result are you getting that is causing you problems? "ianonline" wrote: Hello, Can anyone 'in the know' advise how to add cell1 + cell2 + cell3 and get a numerical result when cell3 may contain a word. Cell3 represent postage and the word, if the order value is is high enough, would be FREE. It's not easy as it looks, it seems! Thank you. Ian -- ianonline ------------------------------------------------------------------------ ianonline's Profile: http://www.excelforum.com/member.php...o&userid=34279 View this thread: http://www.excelforum.com/showthread...hreadid=552764 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you add figure with a word in?
Say your values are in A2, B2 and C2. C2 is the one that shows postage.
Your formula is: =SUM(A2:C2). If these are not in adjacent cells, say in B2, F2 and H2, you may have to use =IF(H2="Free",B2+F2,B2+F2+H2) "ianonline" wrote: Hello, Can anyone 'in the know' advise how to add cell1 + cell2 + cell3 and get a numerical result when cell3 may contain a word. Cell3 represent postage and the word, if the order value is is high enough, would be FREE. It's not easy as it looks, it seems! Thank you. Ian -- ianonline ------------------------------------------------------------------------ ianonline's Profile: http://www.excelforum.com/member.php...o&userid=34279 View this thread: http://www.excelforum.com/showthread...hreadid=552764 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you add figure with a word in?
As Tim said, use the SUM function, it will ignore "FREE". You will get an
error if you just use =cell1+cell2+cell3. Use =SUM(cell1, cell2, cell3) if they are not adjacent. =SUM(cell1:cell3) if they are adjacent. "ianonline" wrote: Hello, Can anyone 'in the know' advise how to add cell1 + cell2 + cell3 and get a numerical result when cell3 may contain a word. Cell3 represent postage and the word, if the order value is is high enough, would be FREE. It's not easy as it looks, it seems! Thank you. Ian -- ianonline ------------------------------------------------------------------------ ianonline's Profile: http://www.excelforum.com/member.php...o&userid=34279 View this thread: http://www.excelforum.com/showthread...hreadid=552764 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sending from excel to word template | Excel Discussion (Misc queries) | |||
Can Excel Export Data to Word Format? | Excel Discussion (Misc queries) | |||
Entering Excel information into MS Word | Excel Discussion (Misc queries) | |||
Embedded word doc changed to image-need to change back to word. | Excel Discussion (Misc queries) | |||
Hyperlink to word document problem | Links and Linking in Excel |