Combining 3 If's

[saltytuna]

Hi

I was wondering if someone could tell me whether I could combine the following formulae into one:

=IF(F2>=B2,"No Extended Credit Period","Extended Period Required")

=IF(G2="No Extended Credit Period","0",ROUNDUP(B2/F2,0))

=IF(AND(H2="0"),"Settle within Term",IF(AND(H2>=1,H2<=3),"1-3 Months",IF(AND(H2>=4,H2<=6),"3-6 Months",IF(AND(H2>=7,H2<=9),"6-9 Months",IF(AND(H2>=10,H2<=12),"9-12 Months",IF(AND(H2>=13,H2<=18),"12-18 Months",IF(AND(H2>=19,H2<=24),"18-24 Months",IF(H2>=25,"24 Months +"))))))))


They are in column's G,H and I respectively.

Thanks

Dee

[Richard Buttrey]

Hi,

You haven't mentioned the precedence. Do we assume that these are taken in order? You'd be better uploading the workbook and manually adding some example results for various permutations so that we know the end goal. There may well be a more efficient way of achieving this.

[Vikas_Gautam]

Hi saltytuna
Try this....
its all yours..

Please Login or Register  to view this content.

Say thanks, Click *

[saltytuna]

Hi Richard

Thanks for coming back to me.

I'm not quite sure what you meant there? But have attached a snapshot of the data I am working on, with the forumlae in the columns as mentioned.

I think there will be a better way also, but very well versed with some of the functions!

Thanks

Dee

[saltytuna]

Hi Vikas

Thank you! I will give it a try now