Forum Discussion

ajl_ahmed's avatar
ajl_ahmed
Iron Contributor
Nov 04, 2024

Data validation

Hi

currently I am using google sheet. I need a function do the following case:

I have data validation in the range (F9:F18) of the attached file. I need a function or formula to set all the values of range (F9:F18) to "P" if the value of F5 is "True" is it possible to do that?

Thanks

Excel for web
office 365

3 Replies

Sort By
  • Mohammed Afifi's avatar
    Mohammed Afifi
    Copper Contributor
    Nov 04, 2024

    Hello Ajl
    yes, it is possible, select range (F9:F18) click data validation go to "Error Alert" and uncheck the error alert invalid entered, press OK

    then go to your rage again select rane (F9:F18) write the following function (=if($f$5="true";"P";"").

    Good Luck
    Mohammed

    • ajl_ahmed's avatar
      ajl_ahmed
      Iron Contributor
      Nov 04, 2024
      Can I share the google sheet link here? I tried to do what you said but I could not. I hope it is possible to share
    • ajl_ahmed's avatar
      ajl_ahmed
      Iron Contributor
      Nov 04, 2024
      Many Thanks
      What if I have another condition beside the value of F5
      the other condition is the range (E9:E18) is not equal to blank.
      How the function will be?

Resources