MrExcel Publishing
Your One Stop for Excel Tips & Solutions

formulas


Posted by Al Stasi on December 31, 2001 3:54 PM

How do I write this formula?

if a cell is equal to or greater than 1 then let one cell equal another.

If C1=>1 then let B1=B5

can you help me?
Thanks,
Al Stasi


Posted by Jacob on December 31, 2001 4:20 PM

Hi

In B1 put =if(C1<1,"",B5)

Jacob