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 ...
  • Harun24HR's avatar
    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,""))))

     

Resources