+ Start a Discussion
pranav shah 40pranav shah 40 

if book price is greater than 500 then Author name and his date of birth is mandatory

how to write avlidation rule for these ..please help

if book price is greater than 500 then Author name and his date of birth is mandatory
Best Answer chosen by pranav shah 40
Deepak Maheshwari 7Deepak Maheshwari 7

Hi Pranav,

Please try below rule:

 

AND(ISBLANK(Author Name), ISBLANK(Date of birth), Bookprice>500)

All Answers

Deepak Maheshwari 7Deepak Maheshwari 7

Hi Pranav,

Please try below rule:

 

AND(ISBLANK(Author Name), ISBLANK(Date of birth), Bookprice>500)

This was selected as the best answer
Deepak Maheshwari 7Deepak Maheshwari 7

Hi Pranav,

 

Hope this works for you!,

If not please let me know.

Deepak Maheshwari 7Deepak Maheshwari 7

Hi Pranav,

 

If this works for you please mark it as best answer