Jump to content

Excel Help

Matsy
By Matsy
in Troubleshooting
 Share
Posted

Hey trying to do one thing in an excel document and I can't seem to do it.

 

I want to make a formula change depending on what I select in a drop down

 

Drop down is in cell E19

I want to change the formula in cell G20 depending on what text is in E19 (Imperial, Metric)

Any help would be appricated

 

Tried

=CHOOSE(E19,E21-E20*2.83,E21-E20)

=IF(E19,E21-E20*2.83,E21-E20)

among others

 

EDIT: NVM sorted it with =IF(E19="Imperial",(E21-E20)*2.83,E21-E20)

PC SYSTEM: Fractal Design Arc Midi R2 / i5 2500k @ 4.2ghz / CM Hyper 212 EVO / Gigabyte 670 OC SLI / MSI P67A-GD53 B3 / Kingston HyperX Blue 8Gb / 

WD 2tb Storage Drive / BenQ GW2750HM - ASUS VE248H - Panasonic TX-P42ST60B/ Corsair AX750 / Logitech K360 / Razer Naga / Plantronics Gamecom 380 /

Asus Xonar DGX / Samsung 830 256gb / MEDIA : eMachine ER1401 running OpenELEC XBMC with Seagate STBV3000200 3TB Hard Drive - Panasonic TX-P42ST60B

Link to comment
https://linustechtips.com/topic/133260-excel-help/
Share on other sites
Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing Troubleshooting

×