Quotation

[sna]

Hi Dear
I need your assistance for quote price.
I have a sheet call quotation price sheet.
I need formula to give a tick mark if the unit price among three is lower otherwise untick mark.Total column cell upon the tick mark cell.
For example
G13:$7
I13:$10
K13:$8
So F13 tick mark
H13 untick mark
J13 untick mark
and so on
Also refer to attached file
Hope you may help


Best wishes

[snasui]

Try this,

F13

=CHAR(IF(COUNTIF($E13:E13,G13),163,IF(G13=MIN($G13,$I13,$K13),82,163)))

Enter and copy formula down and copy F13:F18 paste to H13:H18, J13:J18 respectively.

[sna]

Hi Dear
much appreciated.it works flawlessly.
How about in L2 if unit price is lower then multiply that unit price with quality


Best wishes,

[snasui]

The formula in L13 should be

=MIN(G13:K13)*D13

Press enter and copy down.

In G20 should be

=SUMPRODUCT(--(CODE(F13:F18)=82),$D13:$D18,G13:G18)

Press enter and copy to I20 and K20.

[sna]

Hi Dear
Thank you so much.it works

Best wishes,