Snasui Excel Forum

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

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.

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,

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.

Hi Dear
Thank you so much.it works

Best wishes,