| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How i have #10 in cell when previous#5 and subsequent #15
if i want to create relation between two cells to give number in third cell
for instance i want B6=10 if A6=5 & C6=15 simulatenously |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How i have #10 in cell when previous#5 and subsequent #15
In B6, enter this:
=A6-C6 -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "How i have #10 in cell when previous#5 a" <How i have #10 in cell when previous#5 wrote in message ... if i want to create relation between two cells to give number in third cell for instance i want B6=10 if A6=5 & C6=15 simulatenously |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How i have #10 in cell when previous#5 and subsequent #15
One way:
B6: =IF(AND(A6=5,C6=15),10,"") or, if you were giving a generic example: B6: =C6-A6 In article , How i have #10 in cell when previous#5 a <How i have #10 in cell when previous#5 wrote: if i want to create relation between two cells to give number in third cell for instance i want B6=10 if A6=5 & C6=15 simulatenously |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How i have #10 in cell when previous#5 and subsequent #15
Of course I meant:
=C6-A6 -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Ragdyer" wrote in message ... In B6, enter this: =A6-C6 -- HTH, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "How i have #10 in cell when previous#5 a" <How i have #10 in cell when previous#5 wrote in message ... if i want to create relation between two cells to give number in third cell for instance i want B6=10 if A6=5 & C6=15 simulatenously |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| auto populate cell based on previous cell drop down list selectio. | Excel Discussion (Misc queries) | |||
| formula, move to previous cell when the current cell=0 or empty | Excel Discussion (Misc queries) | |||
| conditional cell format based on cell in same row, previous column | Excel Worksheet Functions | |||
| Select cell, Copy it, Paste it, Return to Previous cell | Excel Discussion (Misc queries) | |||
| Absolute cell references and subsequent problems. | Excel Discussion (Misc queries) | |||
Linear Mode
