IF FUNCTION 1

[ellpis]

I would like to develop a total in F6 by multiplying the quantity in B6 by the lowest price in columns C6, D6, or E6.
Can you help?

 

[DaleWatson123321]

Hi again, ellpis,

Here's the formula I believe you're seeking...

+B6*@MIN(C6..e6)

Because you haven't yet responded to your previous posting - of July 11th - can you please provide an update to both of these postings.

This Lotus forum doesn't get that much activity, so it becomes ESPECIALLY important to provide "feedback".
Such feedback will help to generate more interest and activity in the future.

I hope these formulas help. Please advise as to how you make out with them.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[ellpis]

The formula is accepted, I have rechecked it twice, but no value shows up in the cell

 

[ellpis]

I found that the style in B6 was set as "Label" and the formula would not recognize the number. I change it to "General" and the formula works great.
Thanks again.
Dave