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 10:18 PM.
Hi
Maybe this??
=SUMIF(F2:F3;">0")
Hope to helps you
Regards
Fotis.
I am proud that i am Greek.
Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?
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.
Please,mark your thread [SOLVED] if you received your answer.
My Avadar picture, is from Athens Acropolis.
http://www.theacropolismuseum.gr
http://www.visitgreece.gr/
if(f2*f3>0,f2*f3,"")
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and a dabbler in Cisco
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)
Posting Permissions
Reply With Quote
Bookmarks