Need help with this formula....
=IF(ISBLANK(W5),F5,IF(V5="",((O5*U5)+(P5*T5)+R5),(SUM(O5:Q5)*V5)+R5))
The ISBLANK part works fine. However, if V5 is blank it is only giving me the result in R5 rather than doing the entire calculation. (O5*U5)+(P5*T5)+R5)
Doesn't seem to be much wrong with the formula...
Are you sure V5 is actually "", and doesn't contain a space?
Try attaching a workbook.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
2014_Increase_based_on_2013_data_rev1.xlsx Please see attached file. Highlighted yellow formula that is wrong.
I attached a workbook
s7 isnt blank it has a formula in that resolves to 0 so the last bit is used
,(SUM(L7:N7)*S7)+O7) so you just get the value in o7
you have turned of display 0 in excel options
Last edited by martindwilson; 02-06-2014 at 05:06 PM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
S7 isn't blank, it's 0 - you have 'display zeroes' switched off.
Replace S7="" with S7=0 in your formula.
Thank you!
oh and you dont need all those ()
=IF(ISBLANK(T5),C5,IF(S5="",L5*R5+M5*Q5+O5,SUM(L5:N5)*S5+O5))
That's the beauty of BODMAS!Originally Posted by martindwilson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks