formula result incorrect

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have this formula
{=IF(W15="Within Range","",(H4:I39)*W16)}
my range H4:I39 actually equals 101670.50, and W16 is a formula w the result
of 10%. so the formula result should be 10% of 101670.50, but it returns
303.75, which is about .2%. this has come back across the board and im not
sure why
any help greatly appreciated
 
Formula incorrect not result

=IF(W15="Within Range","",SUM(H4:I39)*W16)

--
Regards,

Peo Sjoblom

(No private emails please)
 
Does this work for you:

=IF(W15="Within Range","",SUM(H4:I39)*W16)
?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Time formula (difference of predicted and actual time) 6
Cell Text Alignment - Not A Centering Issue 4
Comparing Dates in 4 Columns - Nested Formulas? 2
Formula Question (with a name) 2
Excel Need Countifs Formula Help 0
Nested Formula Giving Incorrect Answer 4
incorrect formula result in 2003 3
VLOOKUP returning #N/A result 2

Back
Top