compare values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to compare 3 nonajacent values, bold the lowest value and then
take the lowest value and multiply it by a selected rate of currency.
 
select one of the cells and <format><conditional formating> formula is
cell1<cell 2 set format to bold
select the other cell set conditional format formula is cell 2<cell 1 and
format bold
in the target cell
=min(cell1,cell2)*rate
 
Ididnt notice it was three cells
conditional format formula is and(cell1<cell2,cell1<cell3)
similar for other two cells
and target
=min(Cell1,cell2,cell3)*trate
 
Now that I can do that, I want to take the minimum value and multiply it by a
currency amount that is selected by radio buttons. Help
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PowerPoint Powerpoint image ordering on a single slide 3
Trying to find additional ranges outside of min, max, and average 2
INDEX MATCH SMALL 12
Formula to return lowest value of 3 datapoints 3
Trying to subtract the two lowest values from a row of numbers 4
Conditional Formating: MAX & MIN 3
How do I compare values of two cells and display the lowest. 2
MIN will not find lowest of calculated values How? 5

Back
Top