How do i do a multiplication formula such as =F2*F3 where I only want to know the answer if it is a positive number?
Thank you!
How do i do a multiplication formula such as =F2*F3 where I only want to know the answer if it is a positive number?
Thank you!
Last edited by noviceone; 01-20-2012 at 11:18 PM.
Hi
Maybe this??
=SUMIF(F2:F3;">0")
Hope to helps you
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
if(f2*f3>0,f2*f3,"")
"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
Thanks for your answers. I could not get them to work actually but found the answer elsewhere - I think I should have included the spreadsheet - sorry!
Your help is much appreciated however!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks