Different formulas based on Radio Button

C

Chriselff

New Member
Joined
Oct 21, 2021
Messages
1
Office Version
  1. 365
Platform
  1. Windows
Hello there!

I have a question about the correct use of Radio Buttons. I'm working with an excel sheet (calculator) where the user has 2 options to complete the calculation.

When Highlight Interval is selected the correct formula in the column Equivalent Grade is presented. But when the user selects Residual Interval I need a new formula/ouput to show in the column Equivalent Grade based on the input in 'Residual Row'. Please see the print screen below.

Hope somebody can help me out!
 

Attachments

  • question.png
    question.png
    41.6 KB · Views: 14

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
You must log in or register to reply here.

Similar threads

S
  • Question
Multiple Use Radio or Checkmark Buttons
Replies
2
Views
119
ScottTemple
S
A
  • Question
VBA to change cell colour based on content
Replies
3
Views
171
Snakehips
Snakehips
Kellie220
  • Solved
Formula for calculating different dates/ VBA
Replies
3
Views
160
awoohaw
awoohaw
E
  • Solved
Include the value of a Cell in a SUM based on the selection of a radio button
Replies
6
Views
1K
Excel_User_10k
E
D
  • Question
Slicers/ formulas no longer working
Replies
4
Views
259
dd8
D

Forum statistics

Threads
1,215,045
Messages
6,122,830
Members
449,096
Latest member
Erald

Share this page

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