| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
One Cell (J3) Answer Is Based On Text In Another Cell (I3)...
Here's what I need to do:
If cell I3 has the text "NO", then cell J3 will be equal to cell E3 (basically J3 will have the same number as E3). But If cell I3 has the text "YES", then cell J3 will be E3*L3. What function will complete the above? Thanks, JG |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
One Cell (J3) Answer Is Based On Text In Another Cell (I3)...
=IF(I3="","",IF(I3="NO",E3,IF(I3="YES",E3*L3,"")))
-- HTH Kassie Replace xxx with hotmail "JonGall" wrote: Here's what I need to do: If cell I3 has the text "NO", then cell J3 will be equal to cell E3 (basically J3 will have the same number as E3). But If cell I3 has the text "YES", then cell J3 will be E3*L3. What function will complete the above? Thanks, JG |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
One Cell (J3) Answer Is Based On Text In Another Cell (I3)...
Simply Amazing. That formula worked perfectly. Thanks a bunch.
JG "Kassie" wrote: =IF(I3="","",IF(I3="NO",E3,IF(I3="YES",E3*L3,""))) -- HTH Kassie Replace xxx with hotmail "JonGall" wrote: Here's what I need to do: If cell I3 has the text "NO", then cell J3 will be equal to cell E3 (basically J3 will have the same number as E3). But If cell I3 has the text "YES", then cell J3 will be E3*L3. What function will complete the above? Thanks, JG |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
One Cell (J3) Answer Is Based On Text In Another Cell (I3)...
Do you need the first test, Kassie?
Presumably =IF(I3="","",IF(I3="NO",E3,IF(I3="YES",E3*L3,""))) gives the same result as =IF(I3="NO",E3,IF(I3="YES",E3*L3,"")) ? -- David Biddulph Kassie wrote: =IF(I3="","",IF(I3="NO",E3,IF(I3="YES",E3*L3,""))) Here's what I need to do: If cell I3 has the text "NO", then cell J3 will be equal to cell E3 (basically J3 will have the same number as E3). But If cell I3 has the text "YES", then cell J3 will be E3*L3. What function will complete the above? Thanks, JG |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
One Cell (J3) Answer Is Based On Text In Another Cell (I3)...
"JonGall" wrote: Here's what I need to do: If cell I3 has the text "NO", then cell J3 will be equal to cell E3 (basically J3 will have the same number as E3). But If cell I3 has the text "YES", then cell J3 will be E3*L3. What function will complete the above? Thanks, JG Use the If function if the cell IB contain only 'NO' and 'YES' as shown below. =IF(I3="NO",E3,(E3*L3)) You need nested function if other data is in I3 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
One Cell (J3) Answer Is Based On Text In Another Cell (I3)...
=IF(I3="NO",E3,IF(I3="YES",E3*L3,""))
-- __________________________________ HTH Bob "JonGall" wrote in message ... Here's what I need to do: If cell I3 has the text "NO", then cell J3 will be equal to cell E3 (basically J3 will have the same number as E3). But If cell I3 has the text "YES", then cell J3 will be E3*L3. What function will complete the above? Thanks, JG |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change cell based on answer in another cell | Excel Discussion (Misc queries) | |||
| Change Text Color in one cell based upon entry in referenced cell | Excel Discussion (Misc queries) | |||
| Copy a cell based on check box answer | Excel Discussion (Misc queries) | |||
| Create Cell Comment based on text in a cell on another worksheet | Excel Discussion (Misc queries) | |||
| Excel: Allow combination of formula answer and text in one cell | Excel Worksheet Functions | |||
Hybrid Mode
