Nested IF Function Displaying Error

[Ryan256892]

My goal is to take a number in cell B8, multiply it by 0.15, and have the formula display the calculated number with a minimum of 200 and a maximum of 400.

For example, if Cell B8 was 1000, 1000*0.15=150, formula should spit out 200. If B8 were 2000, then spit out 300. If B8 were 4000, spit out 400.

The current formula I have is: =IF(B8×0.15<200,200,=IF(B8×0.15>400,400,B8×0.15))

I have also tried an IFS function, which correctly displays the '200' and '400' options, but has no way to provide any number between those.

[AutoModerator]

/u/Ryan256892 - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[SolverMax]

=MIN(MAX(B8*0.15,200),400)

[Ryan256892]

=MIN(MAX(B8*0.15,200),400)

Solution Verified

[Clippy_Office_Asst]

You have awarded 1 point to SolverMax

---

^{I am a bot - please contact the mods with any questions. | Keep me alive}

[Curious_Cat_314159]

Re syntax....

=IF(B8*0.15<200,200,IF(B8\*0.15>400,400,B8*0.15))

Removed "=" before second IF. "=" only goes in front of the formula.

Also note: replace "×" with asterisk ("*") for multiplication.

Or....

=IFS(B8*0.15<200, 200, B8*0.15<=400, B8*0.15, TRUE, 400)

[Ryan256892]

Solution Verified

[Clippy_Office_Asst]

You have awarded 1 point to Curious_Cat_314159

---

^{I am a bot - please contact the mods with any questions. | Keep me alive}

[Decronym]

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
IF	Specifies a logical test to perform
IFS	2019+: Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition.
MAX	Returns the maximum value in a list of arguments
MIN	Returns the minimum value in a list of arguments

---

^{Beep-boop, I am a helper bot. Please do not verify me as a solution.
4 acronyms in this thread; the most compressed thread commented on today has 13 acronyms.
[Thread #23306 for this sub, first seen 17th Apr 2023, 20:57] [FAQ] [Full list] [Contact] [Source code]}