I am trying to check if two values are true

**mikejs20** · 10-22-2014, 03:45 PM

Hi I have a table of data I need to check if one cell is =>1500 and another cell is =>15 to give a result

IF D15>500000 AND [@[No of days]]=>14 then ON

I have tried the following but just get an error

=IF((D15>500000) AND ([@[No of days]]=>14), "ON","OFF")

any help appreciated

Mike

**judgeh59** · 10-22-2014, 04:19 PM

very close....give this a try


=IF(AND(D15>500000,[@[No of days]>=14), "ON", "OFF")

**mikejs20** · 10-22-2014, 05:31 PM

Excellent thank you

**judgeh59** · 10-22-2014, 05:44 PM

no problem.....glad I could and thanks for the rep points.....

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

I am trying to check if two values are true

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

I am trying to check if two values are true

Re: I am trying to check if two values are true

Re: I am trying to check if two values are true

Re: I am trying to check if two values are true

Thread Information

Users Browsing this Thread

Similar Threads

Check values of two cells and x if true?

check box when its true

Macro to check range, if false check another range until true, then copy

[SOLVED] check box - true/false/na

Check box - true/false - i'd like a third option n/a

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions