Prev: is this even possible?
Next: Headings
From: yonkersmike on 13 Mar 2010 16:25
i want to come up with a formula where cell b1 *.00125 if its less than 100,
the value must show min 100.00
From: מיכאל (מיקי) אבידן on 13 Mar 2010 16:45
In C1 type: =IF(B1*0.00125<100,100,B1*0.00125)
Micky


"yonkersmike" wrote:

> i want to come up with a formula where cell b1 *.00125 if its less than 100,
> the value must show min 100.00
From: Don Guillett on 13 Mar 2010 17:38
=MAX(B1 *0.00125,100)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"yonkersmike" <yonkersmike(a)discussions.microsoft.com> wrote in message
news:5F9B67B8-B0B4-4B3E-88E0-B369BFF90451(a)microsoft.com...
>i want to come up with a formula where cell b1 *.00125 if its less than
>100,
> the value must show min 100.00

 | 
Pages: 1
Prev: is this even possible?
Next: Headings