Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default formula question...

Just wondering if this is a valid formula...

=(B5*C5)+(B6*C6)
--
curiouscash
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,389
Default formula question...

Yes it is.

Regards,
Fred

"000ani" wrote in message
...
Just wondering if this is a valid formula...

=(B5*C5)+(B6*C6)
--
curiouscash


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 905
Default formula question...

"000ani" wrote:
Just wondering if this is a valid formula...
=(B5*C5)+(B6*C6)


Syntactically, yes. But of course, you could determine that yourself simply
by trying it. So why do you ask?

Despite the fact that it is valid syntactically, there are circumstances
that will cause the formula to fail or not behave as expected.

For example, if any of those cells contains text strings that do not look
like numbers, the formula can return a #VALUE error.

And the formula might not return the expected result because the actual
value of those cells is not the same as displayed value.

If you want to discuss specifics, tell us more about the context of the
question.
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
Newbie Formula Question - how to get formula to repeat in each subsequent row? [email protected] New Users to Excel 2 January 10th 10 05:02 PM
hi, new value formula question RayB Excel Worksheet Functions 5 January 18th 07 03:23 AM
Formula Question Richard Excel Discussion (Misc queries) 2 June 16th 06 09:44 PM
Newbie Question - Subtraction Formula Question [email protected] Excel Discussion (Misc queries) 3 May 5th 06 05:50 PM
Formula Question blackgold21 Excel Discussion (Misc queries) 17 August 28th 05 12:05 PM


All times are GMT +1. The time now is 11:45 PM.

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

About Us

"It's about Microsoft Excel"