Quick question, I'm sure you guys can help.
I'm trying to do an If then formula on a spreadsheet and this is what I have so far
Cell A1= Sale Price
Cell B2= =A1*0.05
Cell C1= =IF(B1<2500,2500,B1)
I'm basically trying to join cell B2 and C1 in one formula without having to create a Cell B2.
How do I incorporate that into one formula?
Thanks in advance!
Cell C1= =IF(A1*0.05<2500,2500,A1*0.05)
Regards, TMS
thanks!
Is there a way to incorporate, if its in between 1 and 2500 to be 2500 but if its 0 to remain 0 and not give me ERROR?
=IF(A1=0,0,IF(A1*0.05<2500,2500,A1*0.05))
Regards, TMS
Thanks for the rep.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks