Data validation formula

[Mime]

Hi All,

I'm working on a pet project with excel and have been somewhat stumped.

I need my data validation to be multiples of cell F6 and less than Cell F6 times G6.

This is where i've gotten to so far:

=ANDC6<=(F6*G6),MOD(C6,F6)

Can someone please help fix the above? Thank you

[bebo021999]

What is criteria of MOD(C6,F6)?

[Mime]

I thought that was C6 must be multiples of F6, it worked initially but i may have changed it too much trying to get the total formula to work.

[bebo021999]

AND formula:

=AND(Logical1, logical2)

in which MOD(C6,F6) is logical2 and it must return TRUE or FALSE, like this: MOD(C6,F6)=1 or >=0

[Mime]

Hey Bebo, i appreciate you trying to help but still unable to get the formula working. Mod (c6, F6) works by itself but when i try to put it in combination with >=(F6*G6) using the and formula it does not work as expected.

[bebo021999]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[Mime]

Thanks Bebo,

In the attached i am trying to get the C column data validated so that it must be entered as a multiple of the F column on the same row and also be smaller than the F column multiplied by G column on the same row.

[bebo021999]

OK, I got it.

Validation for cell C3:

=OR(C3=F3*ROW(INDIRECT("1:"&G3)))

Drag C3 down.

[Mime]

Awesome, thank you so much!