newearwax 12:23 08 Jan 2005
Locked

A relative has asked me to do some analysis of his mobile telephone bills and I am having a problem setting up a formula that will define what call rates would apply to an alternative provider's tariff. In one cell would be the weekday number (mon=1 to sun=7) and in another a decimalised version of the time (8.15pm= 20.25). In the cell where the formula will lie I wish to produce an answer 1 or 2. Conditions are
b) if weekday=5 and time>=20 answer 2
c) if weekday=1 and time =7 answer 2
d) if none of the above conditions fulfilled answer 1.

After several attempts the excel system suggested an answer but that produced #value.

Can anyone assist? Thanks

VoG II 12:30 08 Jan 2005

With weekday in A1, time in B1

=IF(OR(A1>5,AND(A1=5,B1>=20),AND(A1=1,B1=7)),2,1)

newearwax 19:05 08 Jan 2005

Thanks very much.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

iMac Pro review

Visual Trends 2018: This year’s must-know colour, design, branding & photography trends

iMac Pro review

Apple Music : comment obtenir 3 mois gratuits ?