Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default Multiply/Sum cells containing formulas

Hi there,
I need help to performing product on cells containing formulas / hyperlink.
Example on a cell A1=IF((C7=2,"S$200"),IF(C7=3,"S$166")) and in cell
F4=sum(B1:B3) and A2=Product(A1,F4).
Currently, I have error...

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 694
Default Multiply/Sum cells containing formulas

Hi Elynn
In A1 it should be like this:=IF(C7=2,"S$200",IF(C7=3,"S$166"))
in A2 you would like to multiply A1 with F4 "I think" but A1 is considered
text "S$200" and f4 don't know ?
You would need to elaborate on the function Product in A2
Regards
John
"Elynn" wrote in message
...
Hi there,
I need help to performing product on cells containing formulas /
hyperlink.
Example on a cell A1=IF((C7=2,"S$200"),IF(C7=3,"S$166")) and in cell
F4=sum(B1:B3) and A2=Product(A1,F4).
Currently, I have error...


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 73
Default Multiply/Sum cells containing formulas

Your A1 formula should be:
=IF(C7=2,S$200,IF(C7=3,S$166,""))
--
If my posting was helpful, please click the "Yes" button.

ROCK ON!,

Scott


"Elynn" wrote:

Hi there,
I need help to performing product on cells containing formulas / hyperlink.
Example on a cell A1=IF((C7=2,"S$200"),IF(C7=3,"S$166")) and in cell
F4=sum(B1:B3) and A2=Product(A1,F4).
Currently, I have error...

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default Multiply/Sum cells containing formulas

Thanks Both

"porter444" wrote:

Your A1 formula should be:
=IF(C7=2,S$200,IF(C7=3,S$166,""))
--
If my posting was helpful, please click the "Yes" button.

ROCK ON!,

Scott


"Elynn" wrote:

Hi there,
I need help to performing product on cells containing formulas / hyperlink.
Example on a cell A1=IF((C7=2,"S$200"),IF(C7=3,"S$166")) and in cell
F4=sum(B1:B3) and A2=Product(A1,F4).
Currently, I have error...

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
convert & multiply (number & time)formulas targueta Excel Worksheet Functions 11 September 24th 08 10:12 PM
Paste Special - Formulas - Multiply [email protected] Excel Discussion (Misc queries) 4 February 4th 08 03:45 PM
HOW TO MULTIPLY 2 CELLS THAT CONTAIN FORMULAS Kim Excel Discussion (Misc queries) 2 December 13th 06 04:34 PM
add value of 4 cells, multiply by 3 subtract 72 multiply by 80% George A. Yorks Excel Discussion (Misc queries) 10 October 25th 06 09:45 PM
Formulas do not multiply when filled down Frustrated Freddie Excel Worksheet Functions 1 August 1st 05 04:28 AM


All times are GMT +1. The time now is 08:38 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"