formula help

Bizzol

New Member
To make a formula in cell C1, that will take cell B1 and see if it is:
1) <=0, if it is, it should equal cell A1

or

2) if cell B1 is >=.01, then it would equal B1-A1

Hope that makes sense

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
=if(b1<=0,A1,if(b1>=0.1,b1-a1,"between zero and 0.1"))

Assuming that by >=.01 you mean >0 (i.e. 0.00001 would also fall in that category)

=IF(B1<=0,A1,B1-A1)

TREMENDOUS WORK!!!! I'm always glad to get help here! Thanks!

Replies
4
Views
164
Replies
5
Views
453
Replies
5
Views
195
Replies
4
Views
87
Replies
29
Views
409

1,221,185
Messages
6,158,408
Members
451,490
Latest member
desktopace

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back