Here is my scenario, I need to find the best price deal for Furby. Here are the figures. Don't even know where to begin or what to put in to find the "Best Deal" for cell G3. I need some type of Nested IF Function.
Here is my scenario, I need to find the best price deal for Furby. Here are the figures. Don't even know where to begin or what to put in to find the "Best Deal" for cell G3. I need some type of Nested IF Function.
Last edited by momrkof4; 12-07-2012 at 02:17 PM. Reason: Here is the attached file.
may attached a worksheet...
the above is very hard to read...
also, you have 5 stores and only 4 amounts... 3 of which are the same...?
if you just want G3 to be the lowest amount, just use
=MIN(A3:E3)
I sent an attachment, and yes on the first item (Furby) 3 of the stores have the same price, but for some of the other items they are different in price. Any help would be GREATLY appreciated. I have to fill in the entire column for Best Deal.
IF Function.xlsx
if i helped click the star below my name...
Is there any way to incorporate an IF Function? It is one of the requirements for the project. If I used an IF Function to determine which retailer is cheapest, if all the same price then "No Best Deal" would be added.
IF Function (1).xlsx
What do i get for doing your schoolwork Mrs.Mom?
A very biggggggggg thank you!!!!!!!!!!!!!!
mark solved if solved
My wife is from Michigan, so i dont mind helping a michiganer
OMG, THANK YOU!!!!!! You helped me out a ton!!!
First time on here, wish I would have found this site months ago. Where is the Solve at so I can mark it?
top of your post, thread options, mark thread as solved i think...
I am actually headed up to Troy MI tonight to stay with my wifes family, so hahaha...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks