Formula question

thescream80

Board Regular
Joined
Mar 28, 2014
Messages
119
Office Version
  1. 2019
  2. 2016
Platform
  1. MacOS
Here is what I am looking to do:

Column A Column B
X(unknown # =X*.35 If X less than 857 =300. If X is 858 or more than it is X*.35

Any ideas how to do that?

Any help would be great appreciated!!!
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
try in B1

=if(A1<858,300,A1*.35)
 
Upvote 0
Thanks for the quick reply. It is automatically putting it to $300 w/o adding any number to A1
The goal would be it to not show anything until some number goes in A1 then it either reads 300 or X*.35
 
Upvote 0
you didn't mentioned that condition in your post, anyway, try this

=if(isblank(A1),"",A1<858,300,A1*.35))
 
Upvote 0
What if we do something like if the A1 is 1to858 = 300 if 859+= 859*.35. would that work some way?
 
Upvote 0

Forum statistics

Threads
1,213,560
Messages
6,114,306
Members
448,564
Latest member
ED38

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top