excell

  • Thread starter Thread starter yonkersmike
  • Start date Start date
Y

yonkersmike

i want to come up with a formula where cell b1 *.00125 if its less than 100,
the value must show min 100.00
 
In C1 type: =IF(B1*0.00125<100,100,B1*0.00125)
Micky
 

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

average acts different in rows and columns? 6
#DIV/0! in variance/percentage formula 3
Excel 2002 : How to sum range ? 10
Multi-demensional frequency distribution 4
Excel - Grid Lookup 1
Mutiple IF(AND) too many conditions 7
Excel Formula Help 5
I need a formula 4

Back
Top