IF function to automatically catergorise data

[a2424]

hi guys.

i need help with the following if statement. im not very good with the if statement. i need a formula which depending on the value of column a and column b gives an output in text.

for example : if column a = 0 and column b = greater than 0 then column c needs to say Casual Rental
if column a = 0 and column b is than or equal to 0 then column c needs to say Normal
if column a = greater than 0 and column b = less than or equal to 0 then column c needs to say Extension
if column a = greater than 0 and column b = greater than 0 column c needs to say Extension then rental

i have attached my data

i would appreciate any help!

thanks

[Pete_UK]

Put this in C2:

=IF(A2<=0,IF(B2>0,"Casual Rental","Normal"),IF(B2>0,"Extension then Rental","Extension"))

then copy down.

Hope this helps.

Pete

[a2424]

thanks for your help, i have managed to determine which category they fall into via column J. i now need help depending on what the status of the data is.
if the status in column B is Received, Paid Out, Sold or Rent Stopped then i need the category in column J to change to Inactive.
if the status in column B is On Rental then the formula in Column J is correct.

hope this makes sense!

thanks

[Pete_UK]

Well, it's 2:00 am here, so I can't help you anymore tonight - I need some sleep.

Pete

[vlady]

look at the end of the columns for options...

Data workbook.xlsx