Hello All,
I have attached an example spreadsheet showing what I am referring to. What I am trying to do is in column G show totals from Loss or Gain (column F) if the customer price (column B) is greater then $1. If the total (column B) is equal or less than $1 put $0 dollar value in column G.
In G2
=IF(B2<1, 0, F2)
Is that what you need?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Hello ChemistB,
Thank you for the help. The formula is almost right. Look on row 6 the customer prices is $1 and it did not add $0 to the cell. I think the formula needs to be equal and less then $1 equals $0. What do you think?
To make it less or equal to just add an "="
Formula:
Please Login or Register to view this content.
You are awesome!!! Worked like a charm. Thank you!!!
Not a problem, have a great day!
Kind Regards,
Thomas Bailey
Show appreciation by clicking "Add Reputation"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks