Forum Discussion

Rashaud35's avatar
Rashaud35
Copper Contributor
Aug 21, 2022
Solved

If cell is this then change value to this (Help)

Hello, I was hoping for a little assistance if possible:   When a value is manually entered into cell B4 and that value is less than or equal to 1200, then cell A27 should read out values assigned ...
excel
Formulas and Functions
Macros and VBA
  • Harun24HR's avatar
    Harun24HR
    Aug 21, 2022

    Rashaud35 You need nested IF() function. Try-

    =IF(B4<=1200,IF(B5="Light",15000,IF(B5="HEAVY",30000,IF(B5="SUPER HEAVY",60000,""))),IF(B5="Light",25000,IF(B5="HEAVY",50000,IF(B5="SUPER HEAVY",75000,""))))

     

Rashaud35's avatar
Rashaud35
Copper Contributor
Aug 21, 2022

Harun24HR This worked!! Thank you so much for your help buddy. I could for the life of me get this figured out.

Harun24HR's avatar
Harun24HR
Bronze Contributor
Aug 21, 2022
Glad to know! If it helps then please tick mark the answer.

Resources