IF & OR function help required

[trickslide]

Hello Everyone,

I was looking for a little help on a formula, a variation of the IF OR.

The spreadsheet is designed to check the versions of a list of software a client is using.

It checks what the current version against the master list and then returns up to date or

upgrade now.

Each client has their own worksheet, which lists the sware they are using in the first column

and the version in the second column.

I have inserted all the sware available

I have it working up to this point with this formuala
=IF(client!B12=Summary!B12,"up to date","update now")

My stumbling block is where the client does not have that sware installed and I enter N/A or

similar.

I guess the function I am trying to get at is

if the client software version = master list version then show up to dat. If it is not the

same show upgrade now, but if the client version = NA then show not installed.

I hope that makes sence.

Any help would be much appreciated.

Richard

 

[Jonmo1]

Try

=IF(client!B12="NA","Not Installed,IF(client!B12=Summary!B12,"up to date","update now"))

 

[trickslide]

Hi jonmo1,

Worked a treat. Thanks for the fast reply

much appreciated
Richard