Good morning, I am trying to solve a doubt that I have in a formula. In cell A if the value is equal to or less than 0 calculate cell A with B, but if it is greater than zero it should not add to cell B. Thanks.
Good morning, I am trying to solve a doubt that I have in a formula. In cell A if the value is equal to or less than 0 calculate cell A with B, but if it is greater than zero it should not add to cell B. Thanks.
This is a rather compact way to do it.
Formula:Please Login or Register to view this content.
In C2 copied down:
=IF(A1<=0,SUM(A1:B1),B1)
Last edited by AliGW; 05-30-2017 at 01:15 PM. Reason: Silly tyop!!! :)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thanks for the answers, the formula: error appears when I paste it in Excel, I have not been able to test it. The first one I think works, I'll try the file I need to see if it works. When you try it, notice if it works.
Which of us are you addressing? If my solutions are untested, I say so. Here they have been tested. See below:
Excel 2016 (Windows) 32 bit
A B C 1 2170 2106.82 63.18
Sheet: Sheet1
Excel 2016 (Windows) 32 bit
A B C 1 2170 =A1-(A1*0.029)-0.25 =A1-(A1-(A1*0.029)-0.25)
Sheet: Sheet1
Well spotted! Doh!!! I'll amend my original post.
Thanks, it works perfectly. Thank you very much for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks