Previous Topic Next Topic

Need help with a formula please!!!!!

Solved/Closed
Wickedsi Posts 5 Registration date Thursday March 11, 2010 Status Member Last seen March 11, 2010 - Mar 11, 2010 at 04:08 PM
Wickedsi Posts 5 Registration date Thursday March 11, 2010 Status Member Last seen March 11, 2010 - Mar 11, 2010 at 08:31 PM
Hello,

I and creating a spreed sheet for my job to make weekly counts easier. I have been trying for hours now on a formula to calculate either a greater than less than with in two cells.

IE: If b22 is greater Than c22 then add, if b22 is less than c22 then subtract. (Dealing with Inventory Costs)

Please if you can help!!!
Related:

4 responses

Answer 1 / 4
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 11, 2010 at 05:59 PM
presuming you want this to happen in cell A22 then

in A22 write

=IF(B22>C22, B22+c22, IF(B22<C22, C22-B22, "what should i do if b22 is same as c22"))
0
Answer 2 / 4
Wickedsi Posts 5 Registration date Thursday March 11, 2010 Status Member Last seen March 11, 2010
Mar 11, 2010 at 07:18 PM
I tried that and it did not work. The numbers will never be the same.
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 11, 2010 at 07:32 PM
What you mean exactly by it did not work ? you got error? not expected answer. Could you provide sample data along with what output you expect
0
Answer 3 / 4
Wickedsi Posts 5 Registration date Thursday March 11, 2010 Status Member Last seen March 11, 2010
Mar 11, 2010 at 07:36 PM
Sorry the ""what should i do if b22 is same as c22 Threw me off. Thank kindly for your help!
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 11, 2010 at 07:40 PM
Sorry, I was trying to be cheeky. Lesson learned dont try to be smart.
0
Answer 4 / 4
Wickedsi Posts 5 Registration date Thursday March 11, 2010 Status Member Last seen March 11, 2010
Mar 11, 2010 at 08:31 PM
Lol I tried the smart and i failed! I could never get it right. Thanks again so much for the help.

Cheers
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response