Ferrydriver
New Member
- Joined
- Mar 11, 2020
- Messages
- 26
- Office Version
- 2007
- Platform
- Windows
The setup:
Three Cells A1 A2 A3
A1 has value $0.00
A2 is a form control 'Tax' with a click on/off button box
A3 contains a set dollar amount $200.00
Goal:
To transfer the $200.00 into cell A1 if A2 is clicked 'on'
If A2 is not clicked or clicked 'off', A1 remains $0.00
Problem:
Probably the wrong route
I placed a format control button in A2 with cell link A2
I have tried an =IF satement
=IF(A2=FALSE,A1=0,A3)
When the button is 'on' the $200.00 is shown in A1
When the button is 'off' A1 shows 'FALSE'
I would like A1 to show $0.00 not 'FALSE'
Three Cells A1 A2 A3
A1 has value $0.00
A2 is a form control 'Tax' with a click on/off button box
A3 contains a set dollar amount $200.00
Goal:
To transfer the $200.00 into cell A1 if A2 is clicked 'on'
If A2 is not clicked or clicked 'off', A1 remains $0.00
Problem:
Probably the wrong route
I placed a format control button in A2 with cell link A2
I have tried an =IF satement
=IF(A2=FALSE,A1=0,A3)
When the button is 'on' the $200.00 is shown in A1
When the button is 'off' A1 shows 'FALSE'
I would like A1 to show $0.00 not 'FALSE'